Difference between two columns in Matrix

[Anonymous]

Hi guys,

Can someone help me with the following:

I need to create 5 more columns which respectively will be the difference between 2020 and 2019.

I'm quite sure I'll need some kind of custom measure for it, just don't know which.

Thank you in advance.

[v-shex-msft]

Hi @Anonymous,

I think you can create a calculation table with all column category that you used on the snapshot.
Then you can use it on the column fields of the matrix and write a measure with switch function to check current row content and category to return special expression results.

Regards,
Xiaoxin Sheng

[parry2k · Accepted solution]

@Anonymous assuming you have date dimension in your model, if yes, good, otherwise add one and then add following measure:

Difference from PY = 
VAR __prevYear = CALCULATE ( SUM ( Table[Sales] ), PREVIOUSYEAR ( DateTable[Date] ) )
RETURN
SUM ( Table[Sales] ) - __prevYear

if you already have a measure, then use that instead of SUM ( Table[Sales] )

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡