Forum Discussion
esterdid
8 years agoFrequent Visitor
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
- v-yulgu-msftMicrosoft Employee