Forum Discussion
Solved
Difference between two values from seperate dates with refresh option
Hey there, I have been running into the issue that I have a dataset that consists of total values for various dates throughout the year that is reported into the same dataset. I want to set...
Hi jksl_12,
I think you want to have this result :
You can use this measure :
Dif with Max Date =
VAR MaxDate =
CALCULATE ( MAX ( 'Feuil2'[Date] ), ALL ( Feuil2[Date] ) )
VAR AmountMaxDate =
CALCULATE ( SUM ( 'Feuil2'[Amount] ), 'Feuil2'[Date] = MaxDate )
RETURN
SUM ( Feuil2[Amount] ) - AmountMaxDateIf a new date comes in your data, it will take its value.Hope it helps 😀!Regards
dadb25
Helper I
Helper IMark my post as a solution if it helped you 😀