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
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

Using the Query Editor, right click on the Company Name heading > Group By.  Select SUM as the function for Revenue and MAX as the function for Sale Date.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks but I need a new table with these aggragations not an aggregation of the current table.