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

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.