How to calculate a difference

Question

Hello, I am new to Power BI, and I am trying to solve one (probably easy) task, but not sure how.&nbsp;Let me simplify it:&nbsp;I have data in such format:YEAR&nbsp; &nbsp;Company Result2023&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1002022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1502022&nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1202021&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2502022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50...&nbsp;Then I already have a visual - table created:&nbsp; &nbsp; &nbsp; &nbsp;2021 - Result&nbsp; &nbsp; 2022 - Result&nbsp; &nbsp; 2023 - ResultA&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100B&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0C&nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0D&nbsp; &nbsp; &nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0Total&nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp;And I need to add one more column to this existing visual to calculate "Difference" 2023-2022. How can I do it, please?&nbsp;Thanks.Katarína&nbsp;

eliasayyy · Accepted Answer

Give you made a matrix table&nbsp;Please try&nbsp;Difference =&nbsp;VAR _y = [result]VAR _ly = CALCULATE([result],calendar[year] = MAX(Calendar[year]) -1)RETURN_y - _yl

Forum Discussion

How to calculate a difference

2 Replies

Related content

Dynamic Calculation Different Period

Different Calculations

Calculating Differences

Calculating day/time difference

How to add two different calculated columns of two different table