compare value based on 2 date selected

[Anonymous]

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!

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Kindly check my below results:

Pbix attached.

[Anonymous]

The Table 2 = CALENDAR(DATE(2019,1,1),DATE(2019,12,31)) did the trick!!!

Amazing! thanks a lot!!

[amitchandak]

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

[Anonymous]

'All' is my table, the diff is always 0.

DateDifference =

var _max = MAXX('All', 'All'[Date])

var _min = MINX('All', 'All'[Date])

return

calculate(sum('All'[pageview]),filter(ALL('All'[Date]),'All'[Date]=_max)) - calculate(sum('All'[pageview]),filter(ALL('All'[Date]),'All'[Date]=_min))