Forum Discussion
Subtracting from the same column based on selected filter
Hi Power Bi Community,
I need your support on writting DAX commend.
I've a table that consist of project ID and Turnover over the years.
| Project ID | Turnover MEUR | Year |
| ID99 | 0,1 | 2021 |
| ID98 | 0,5 | 2021 |
| ID99 | 0,3 | 2022 |
| ID98 | 0,7 | 2022 |
| ID99 | 0,5 | 2023 |
| ID98 | 0,9 | 2023 |
I'd like to subtract turnover over years, in order to be able calculate the growh. In other words,
Growth = Turnover 2022 (ID99) - Turnover 2021 (ID99), Turnover 2023 (ID99) - Turnover 2022 (ID99), Turnover 2022 (ID98) - Turnover 2021 (ID98) ...etc.
Any ideas, how I can write this in DAX command ?
Hi Anonymous
Please refer to the sample with the solution https://www.dropbox.com/t/80L2KufXOL8k8xLcTurnover YOY = VAR CurrentYer = SELECTEDVALUE ( Turnover[Year] ) VAR FirstSelectedYear = CALCULATE ( MIN ( Turnover[Year] ), ALLSELECTED ( Turnover ) ) VAR CurrentValue = SUM ( Turnover[Turnover MEUR] ) VAR PreviousValue = CALCULATE ( SUM ( Turnover[Turnover MEUR] ), Turnover[Year] = CurrentYer - 1 ) RETURN IF ( CurrentYer <> FirstSelectedYear, CurrentValue - PreviousValue )
2 Replies
- tamerj1
Community Champion
Hi Anonymous
Please refer to the sample with the solution https://www.dropbox.com/t/80L2KufXOL8k8xLcTurnover YOY = VAR CurrentYer = SELECTEDVALUE ( Turnover[Year] ) VAR FirstSelectedYear = CALCULATE ( MIN ( Turnover[Year] ), ALLSELECTED ( Turnover ) ) VAR CurrentValue = SUM ( Turnover[Turnover MEUR] ) VAR PreviousValue = CALCULATE ( SUM ( Turnover[Turnover MEUR] ), Turnover[Year] = CurrentYer - 1 ) RETURN IF ( CurrentYer <> FirstSelectedYear, CurrentValue - PreviousValue )