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 all,
Im trying to write a DAX to calculate % difference with benchmark value. The tricky is I will have weekly data added in, so I want to show the % difference per week basis.
Below input:
Disired result:
Thank you!
Hi @milkynight ,
The way to do this is to go to PowerQuery. Select the column with (A, B, C) and choose unpivot other columns. Result:
Then you can create a measure like this:
Jori
If I answered your question, please mark it as a solution to help other members find it more quickly.
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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |