Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Tevon713
Helper IV
Helper IV

Find difference of selected dates for measure calculation

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

 

Tevon713_0-1654635321568.png

 

Matrix showing Blank for Difference:

 

Tevon713_1-1654635402718.png

 

 

1 ACCEPTED SOLUTION
Ashish_Mathur
Super User
Super User

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

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.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks @Ashish_Mathur.

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@Tevon713 , This need at least one independent date table

 

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.