Forum Discussion
Solved
Show difference between rows filtered by date
I've got a Contacts table with id by date. Sometimes a contact does not have a date. Contacs table id date 1 2 1/1/2020 3 1/2/2020 4 1/2/2020 5 6 2/2/2020 7 ...
Dicko , Try a measure like
measure =
var _max= calculate(max(Table[date]) , filter(allselected(Table), Table[date] < Max(Table[date])))
return
sum(Table[amount]) - calculate(sum(Table[amount]), filter(allselected(Table), Table[date] =_max))
Dicko , Try a measure like
measure =
var _max= calculate(max(Table[date]) , filter(allselected(Table), Table[date] < Max(Table[date])))
return
sum(Table[amount]) - calculate(sum(Table[amount]), filter(allselected(Table), Table[date] =_max))