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.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi HishamAT 

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

  • 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 ) .