Find difference of selected dates for measure calculation

[Tevon713]

Hello all,

I need help in trying to find difference in a measure when user select 2 date or year/month. Just getting blank, not sure if the formula or can you find difference in a measure.

Please help and advise. Thanks.

Below is link to sample pbix file.

https://www.dropbox.com/s/yq7os1gkf9e6y0s/Find%20difference%20of%20selected%20dates.pbix?dl=0

Difference measure

Matrix showing Blank for Difference:

[Ashish_Mathur · Accepted solution]

Hi,

Download the PBI file from here.  The answer is 0 in the Diff column because even in a different year, the Region and Site name combination changes.

[Tevon713]

Thanks @Ashish_Mathur.

[Ashish_Mathur]

You are welcome.

[amitchandak]

@Tevon713 , This need at least one independent date table

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg