DAX for comparison of weekly sales vs benchmark

[milkynight]

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!

[jppv20]

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:

Week vs BM = DIVIDE(SUM(Sales[Value])-SUM(Benchmark[BM]),SUM(Benchmark[BM]),BLANK())

Then put it in a Matrix to get this result:

Jori

If I answered your question, please mark it as a solution to help other members find it more quickly.