Forum Discussion
lastnn30
Post Patron
Post PatronTable 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 ...
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
Super User
Super UserHi,
Share the download link of the file 8.xlsx
lastnn30Thank you. Here is the link
Thanks again
- Ashish_Mathur
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.