topic Re: Subtracting from the same column based on selected filter in DAX Commands and Tips

Subtracting from the same column based on selected filter

Anonymous — Thu, 21 Jul 2022 11:22:31 GMT

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 ?

Re: Subtracting from the same column based on selected filter

tamerj1 — Thu, 21 Jul 2022 11:46:05 GMT

Hi Anonymous
Please refer to the sample with the solution https://www.dropbox.com/t/80L2KufXOL8k8xLc

Turnover 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 )

Re: Subtracting from the same column based on selected filter

Anonymous — Tue, 26 Jul 2022 10:54:57 GMT

Hi tamerj1 ,

Worked like a charm! Thanks for such detailed sulution!