Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Power Bi will add all Liz's transcations and give one number instead of 4. Also the Grand total is not added automatically in my table. Thank you very much.
PS: the Power BI file is here
https://drive.google.com/file/d/1XVIJgkdbRpouHIhjJv_U3GfUFp9KeLy0/view?usp=sharing
Solved! Go to Solution.
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.
Thank you very much.
You are welcome.
@lastnn30 Hi First change relationship as from Single to Both as per below snap:
Then create measure as per below:
Measure = var _S = SUM('Table (2)'[Amount])
var _C = SUM('Table (2)'[Amount]) * MIN('Table (3)'[Commision])
var _F = _S - _C
return
_F
finally create table as per below:
Table = SUMMARIZE('Table', 'Table'[SalesPerson], "Raq" ,[Measure])
Hi,
Share the download link of the file 8.xlsx
Thank you. Here is the link
Thanks again
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |