Forum Discussion
How to calculate a difference
Hello, I am new to Power BI, and I am trying to solve one (probably easy) task, but not sure how. Let me simplify it: I have data in such format: YEAR Company Result 2023 A ...
Give you made a matrix table
Please try
Difference =
VAR _y = [result]
VAR _ly = CALCULATE([result],calendar[year] = MAX(Calendar[year]) -1)
RETURN
_y - _yl
many thanks for your help!