Friday, January 7, 2022

DAX - SELECT with GROUP BY = EVALUATE SELECTCOLUMNS ( SUMMARIZECOLUMNS))

 EVALUATE

SELECTCOLUMNS (
SUMMARIZECOLUMNS(
    SAP_FAT_Vendas_py[PLANT],
    SAP_FAT_Vendas_py[CALDAY],
    SAP_FAT_Vendas_py[/BIC/ZCARDNUM1],
    SAP_FAT_Vendas_py[CUST_SALES],
    SAP_FAT_Vendas_py[/BIC/ZMATERIAL],
    "Vol3", [.Vol3],
    "QtdRegs", [.QtdRegs]
),
    SAP_FAT_Vendas_py[PLANT],
    SAP_FAT_Vendas_py[CALDAY],
    "CARDNUM1",SAP_FAT_Vendas_py[/BIC/ZCARDNUM1],
    SAP_FAT_Vendas_py[CUST_SALES],
    "MATERIAL", SAP_FAT_Vendas_py[/BIC/ZMATERIAL],
    "Vol3", [Vol3],
    "QtdRegs", [QtdRegs]
)

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE