Forum Discussion
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 | 1/3/2020 |
Now I want to show the difference in number of contacts per row, with the possibility to filter on month or day.
(The difference is shown on the next row.)
Visual result when showing all dates
| date | amount | difference |
| 1/1/2020 | 1 | |
| 1/2/2020 | 2 | 1 |
| 2/2/2020 | 1 | -1 |
| 1/3/2020 | 1 | 0 |
Visual result when filtered on february
| date | amount | difference |
| 1/2/2020 | 2 | |
| 2/2/2020 | 1 | -1 |
How do I go about this?
Kind regards.
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))
1 Reply
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))