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 a table containing productcode and achieved price for each sale (row).
Now I want to calculate the difference from the average sale for the actual product on each row, like this:
Product | Achieved price | Diff from average price |
A | 50 | -8,333 |
A | 60 | 1,666 |
A | 65 | 6,666 |
B | 187 | -2,500 |
B | 192 | 2,500 |
C |
And there are about 30000 sales and 50 products in the current table.
I've tried some combinations of AVERAGE (would prefer MEDIAN though) but I just don't get how to filter on products...
Anyone?
Regards,
John
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 | |
96 | |
79 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |