Diffrance between 2 values at different years.

[HishamAT]

Hi

• 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

[FreemanZ]

hi @HishamAT 

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

[HishamAT]

- 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

[v-rongtiep-msft]

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.

[HishamAT]

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

[v-rongtiep-msft · Accepted solution]

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.

[HishamAT]

Thanks for your support , It works fine.