Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculate table - aggragation

I need to create an aggragated table based on a table within my Power BI app.   Basically  I have the following fields in the base tablein my Power BI app: Company Revenue Sale Date   I want t...
Need Help
LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Anonymous

 

= 
SUMMARIZECOLUMNS(
    Sales[Company],
    "SaleAmount", SUM( Sales[Revenue] ),
    "LastDate", MAX( Sales[Sale Date] )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Awesome Thanks!  So "SUMMARIZECOLUMNS" has the same effect as "CALCULATETABLE" - either of them can be used to create a new table from a current table in your Power BI app?