Forum Discussion
How to get the difference between more rows?
tamerj1 could you please help me? i am lost
Apologies for the late response. I was extremely busy tody I didn't have the chance to look into it.
Actually, this shouldn't be a problem we just need to filter the table or sort it by date then retrieve the amount for both max and min dates.
Value =
VAR MeasureValue =
SUM ( 'Zusammenfassung'[Value] )
VAR T1 =
ADDCOLUMNS (
VALUES ( 'Zusammenfassung'[Source.Name] ),
"@Date", CALCULATE ( MAX ( 'Zusammenfassung'[Date] ) ),
"@Value", CALCULATE ( SUM ( 'Zusammenfassung'[Value] ) )
)
VAR FirstRecod =
TOPN ( 1, T1, [@Date], ASC )
VAR LastRecod =
TOPN ( 1, T1, [@Date] )
VAR DifferenceValue =
MAXX ( LastRecod, [@Value] ) - MAXX ( FirstRecod, [@Value] )
RETURN
IF (
HASONEVALUE ( 'Zusammenfassung'[Source.Name] ),
MeasureValue,
DifferenceValue
)
*UPDATE
The measure has been updated fixing one error KimBoehmer
Hi tamerj1 dont worry 🙂
i have tested your formular, but the result its unfortunately not correct 😞
Here two examples:
BR Kim
Please copy/paste the formula that you've used. Did you check the updated formula?
Yes, now it shows this:
For [Date] you need to use your month column. The month column has to be of YYYYMM format.
Hi, i did it but get no result:
The error is gone but there is no output