Show difference between rows filtered by date

[Dicko]

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.

[amitchandak · Accepted solution]

@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))