topic How to calculate a difference in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374069#M127033 <P>Hello, I am new to Power BI, and I am trying to solve one (probably easy) task, but not sure how.</P><P>&nbsp;</P><P>Let me simplify it:</P><P>&nbsp;</P><P>I have data in such format:</P><P>YEAR&nbsp; &nbsp;Company Result</P><P>2023&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>2022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150</P><P>2022&nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P><P>2021&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P><P>2022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50</P><P>...</P><P>&nbsp;</P><P>Then I already have a visual - table created:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;2021 - Result&nbsp; &nbsp; 2022 - Result&nbsp; &nbsp; 2023 - Result</P><P>A&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; 100</P><P>B&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;0</P><P>C&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;0</P><P>D&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; 0</P><P>Total&nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp;</P><P>And I need to add one more column to this existing visual to calculate "Difference" 2023-2022. How can I do it, please?</P><P>&nbsp;</P><P>Thanks.</P><P>Katarína</P><P>&nbsp;</P> Thu, 10 Aug 2023 11:40:40 GMT Anonymous 2023-08-10T11:40:40Z How to calculate a difference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374069#M127033 <P>Hello, I am new to Power BI, and I am trying to solve one (probably easy) task, but not sure how.</P><P>&nbsp;</P><P>Let me simplify it:</P><P>&nbsp;</P><P>I have data in such format:</P><P>YEAR&nbsp; &nbsp;Company Result</P><P>2023&nbsp; &nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100</P><P>2022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150</P><P>2022&nbsp; &nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;120</P><P>2021&nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;250</P><P>2022&nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50</P><P>...</P><P>&nbsp;</P><P>Then I already have a visual - table created:</P><P>&nbsp; &nbsp; &nbsp; &nbsp;2021 - Result&nbsp; &nbsp; 2022 - Result&nbsp; &nbsp; 2023 - Result</P><P>A&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; 100</P><P>B&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;0</P><P>C&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;0</P><P>D&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; 0</P><P>Total&nbsp; 250&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 320&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 100</P><P>&nbsp;</P><P>And I need to add one more column to this existing visual to calculate "Difference" 2023-2022. How can I do it, please?</P><P>&nbsp;</P><P>Thanks.</P><P>Katarína</P><P>&nbsp;</P> Thu, 10 Aug 2023 11:40:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374069#M127033 Anonymous 2023-08-10T11:40:40Z Re: How to calculate a difference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374081#M127035 <P>Give you made a matrix table</P><P>&nbsp;</P><P>Please try</P><P>&nbsp;</P><P>Difference =&nbsp;</P><P>VAR _y = [result]</P><P>VAR _ly = CALCULATE([result],calendar[year] = MAX(Calendar[year]) -1)</P><P>RETURN</P><P>_y - _yl</P> Thu, 10 Aug 2023 11:48:21 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374081#M127035 eliasayyy 2023-08-10T11:48:21Z Re: How to calculate a difference https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374129#M127042 <P>many thanks for your help!</P> Thu, 10 Aug 2023 12:14:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-calculate-a-difference/m-p/3374129#M127042 Anonymous 2023-08-10T12:14:41Z