topic Re: Diffrance between 2 values at different years. in DAX Commands and Tips

Diffrance between 2 values at different years.

HishamAT — Sun, 18 Dec 2022 06:10:24 GMT

Let's say that I have a field called NHC = 7.6 at year 2022 on the month of December
Same field at year 2019 was 10.4 at the month of December
I need to calculate the difference between the same fields for the same month in the years 2022 and 2019

Thanks

Re: Diffrance between 2 values at different years.

FreemanZ — Sun, 18 Dec 2022 06:21:26 GMT

hi HishamAT

seems not very doable. could you also provide some sample data and how you would like to present the result?

Re: Diffrance between 2 values at different years.

HishamAT — Sun, 18 Dec 2022 09:48:54 GMT

- NHC = 7.6 at year 2022 on the month of December

- NHC = 10.4 at year 2019 on the month of December

I need to calculate the difference between the same fields for the same month in the years 2022 and 2019

Re: Diffrance between 2 values at different years.

Anonymous — Tue, 20 Dec 2022 02:19:11 GMT

Hi HishamAT ,

Please have a try.

Create a measure.

measure = VAR _year = EDATE ( MAX ( 'Table 2'[Date] ), -36 ) VAR _value = CALCULATE ( MAX ( 'TABLE'[NHC COLUMN NAME] ), FILTER ( ALL ( TABLE ), 'TABLE'[DATE] = SELECTEDVALUE ( 'TABLE'[DATE] ) ) ) RETURN MAX ( 'TABLE'[NHC COLUMN NAME] ) - _value

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Diffrance between 2 values at different years.

HishamAT — Tue, 20 Dec 2022 12:07:58 GMT

Great Sir, is that any way to make the 36 a dynamic date such 1 ,2, 3 .... etc ( As requested by the user ) .

Re: Diffrance between 2 values at different years.

Anonymous — Wed, 21 Dec 2022 01:21:12 GMT

Hi HishamAT ，

I can only think of a simpler way. The first is to directly modify the numbers in the formula. Another way is to use slicers.

Measure = -SELECTEDVALUE('Table'[Column1])

Measure 2 = EDATE ( MAX ( 'Table 2'[Date] ), [Measure] )

EDATE function (DAX) - DAX | Microsoft Learn

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Diffrance between 2 values at different years.

HishamAT — Wed, 21 Dec 2022 07:44:39 GMT

Thanks for your support , It works fine.