Date slicer - get days between dates

[Anonymous]

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

[danno · Accepted solution]

Hi - will this do the trick?

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

[v-yulgu-msft · Accepted solution]

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

[danno · Accepted solution]

Hi - will this do the trick?

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