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 same fields for the same month in the years 2022 and 2019

Thanks

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

6 Replies

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