combine summary table

[esterdid]

Hello,

I am having a bit of challenge and need some suggestions.

I am summarising some data into a table inside powerbi. I am going to have 4 summary tables with simmilar columns . how can I combine those tables into one in the end? the append option is only present in the query mode.

or is there a way to write all the summaries in the same code like :

New Summary = SUMMARIZE('Fact','Fact'[AccountCode],'Calendar'[MonthName],'Calendar'[FY], "VALUES1",CALCULATE(TOTALMTD([Net Sales],'Calendar'[Date])))

SUMMARIZE('Fact','Fact'[Account Code],'Calendar'[MonthName],'Calendar'[FY], "VALUES1",CALCULATE(TOTALMTD([Net Budget],'Calendar'[Date])))

[v-yulgu-msft · Accepted solution]

Hi @esterdid,

You can combine the 4 summarized tables via UNION function.

Regards,

Yuliana Gu