Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
HishamAT
Helper II
Helper II

Diffrance between 2 values at different years.

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

 

vpollymsft_0-1671585570070.pngvpollymsft_1-1671585579966.png

 

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.

View solution in original post

6 REPLIES 6
FreemanZ
Super User
Super User

hi @HishamAT 

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

- 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

 

 

Anonymous
Not applicable

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.

 

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

Anonymous
Not applicable

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

 

vpollymsft_0-1671585570070.pngvpollymsft_1-1671585579966.png

 

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.

Thanks for your support , It works fine.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.