Forum Discussion

esterdid's avatar
esterdid
Frequent Visitor
8 years ago
Solved

combine summary table

 

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])))

1 Reply