Forum Discussion
Difference in Values
Hello, How can I get a differene from the last value? In this example I need the difference in mileage from the last entry. (24,695 - 18,923) (30,781 - 24,695) etc Example) Shou...
You can share a download link
Ok got it:
Change in Mileage = SUMX (
FILTER (
'PM On Time Performance Bus PM-BI-002 (2)',
'PM On Time Performance Bus PM-BI-002 (2)'[Equipment.Equipment Level 01.Key] <= EARLIER ( 'PM On Time Performance Bus PM-BI-002 (2)'[Equipment.Equipment Level 01.Key] )
),
'PM On Time Performance Bus PM-BI-002 (2)'[Mileage]
)
just need to apply the 0 else from before