Forum Discussion

HishamAT's avatar
HishamAT
Icon for Helper II rankHelper II
3 years ago
Solved

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 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
HishamAT
Icon for Helper II rankHelper II
3 years ago

- 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's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    HishamAT
    Icon for Helper II rankHelper II
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        HishamAT
        Icon for Helper II rankHelper II
        3 years ago

        Thanks for your support , It works fine.