Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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))
@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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |