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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Date slicer - get days between dates

Hi,

 

I'm trying to get the number of days on the date slicer to compute a measure by group show it on a chart. 

As a measure this is not a problem.

The chalange is how to get the number of days and use it on a calculated table?

 

I added the file with an example.

https://1drv.ms/f/s!AuFm6kI8W45mgc0CoXZk7JbGbk3Phg

 

Thank you in advance.

All the best

Joao

 

 

2 ACCEPTED SOLUTIONS
danno
Resolver V
Resolver V

Hi - will this do the trick?

Selected Days = COUNTROWS(ALLSELECTED('Date'[Date]))

 

View solution in original post

v-yulgu-msft
Employee
Employee

Hi @Anonymous ,

 

You want to get the date interval within the date range selected by slicer, right?

 

If so, please use:

Datediff=DATEDIFF( MIN ( 'Date'[Date] ), MAX ( 'Date'[Date] ), DAY))
If I have something misunderstood, please provide more description about your expected result.
 
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yulgu-msft
Employee
Employee

Hi @Anonymous ,

 

You want to get the date interval within the date range selected by slicer, right?

 

If so, please use:

Datediff=DATEDIFF( MIN ( 'Date'[Date] ), MAX ( 'Date'[Date] ), DAY))
If I have something misunderstood, please provide more description about your expected result.
 
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
danno
Resolver V
Resolver V

Hi - will this do the trick?

Selected Days = COUNTROWS(ALLSELECTED('Date'[Date]))

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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