Forum Discussion

lastnn30's avatar
lastnn30
Post Patron
3 years ago
Solved

Table does not summarize

Hi I have 3 tables and I merge them using PQ. Now I want to create a table in PowerBI which shows SalesPerson and Amount (Net). When I creat a table, it wont summerize (add). For example, I expect ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Download the PBI file from here.  The data type of he net column was Text.  I changed it to Decimal in the Query Editor an wrote a simple SUM measure.

    Hope this helps.

    Also, changed one relationship (this is not required thought because you have merged data from all tables to just 1.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Share the download link of the file 8.xlsx

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Download the PBI file from here.  The data type of he net column was Text.  I changed it to Decimal in the Query Editor an wrote a simple SUM measure.

    Hope this helps.

    Also, changed one relationship (this is not required thought because you have merged data from all tables to just 1.