Forum Discussion
compare value based on 2 date selected
HI all, I'm new to PowerBI and figuring out the way to visulize result of 2 date comparison.
Raw data I have:
| Page | Date | PageView |
| A | 2019 Mar 2 | 15 |
| A | 2019 Mar 4 | 20 |
| A | 2019 Mar 10 | 5 |
| B | 2019 Mar 2 | 8 |
| B | 2019 Mar 3 | 16 |
| B | 2019 Mar 4 | 20 |
| C | 2019 Mar 5 | 100 |
Expected output:
[Filter, only select 2 date per report, e.g. i select Mar-2 & Mar 4]
| Page | 2019 Mar 2 | 2019 Mar 4 | Difference |
| A | 15 | 20 | 5 |
| B | 8 | 20 | 12 |
| C | 0 | 0 | 0 |
*OK not showing C if there's no value on that date.
Thanks in advance!
Hi Anonymous
Kindly check my below results:
Pbix attached.
4 Replies
Anonymous
Prefer a diff measure like given below. Prefer 1st if it works
Measure =
var _max = maxx(Date,date[Date])
var _min = maxx(Date,date[Date])
return
calculate(sum(Table[PageView]),date[Date]=_max) - calculate(sum(Table[PageView]),date[Date]=_min)
Measure =
var _max = maxx(Date,date[Date])
var _min = maxx(Date,date[Date])
return
calculate(sum(Table[PageView]),filter(all(Date),date[Date]=_max)) - calculate(sum(Table[PageView]),filter(all(Date),date[Date]=_min))Hi Anonymous
Kindly check my below results:
Pbix attached.
