Wednesday, February 24, 2021

DAX - Create Table JOIN / UNION

 FAT_wGalaxy = UNION(

    SELECTCOLUMNS(FAT_wGalaxy_R,"Data",[Data],"Valor",[Valor],"Obs",[Observacao],"Conta",[Conta],"CD",[.ReceitaDespesa],"Classe",[.Classe],"Real_Prev",[Pago_Projetado],"Status",[Status],

    "Data_Pag",if(ISBLANK([Data_PAG]),[Data],[Data_PAG])),

    

    SELECTCOLUMNS(FAT_wGalaxy_D,"Data",[Data],"Valor",[Valor],"Obs",[Observacao],"Conta",[Conta],"CD",[.ReceitaDespesa],"Classe",[.Classe],"Real_Prev",[Pago_Projetado],"Status",[Status],

    "Data_Pag",if(ISBLANK([Data_PAG]),[Data],[Data_PAG]))

    

    )

No comments:

Post a Comment

Power BI APP - Delete or Unpublish

 UNPUBLISH DELETE