Solved: Re: date difference by date filter

Anonymous · ‎02-16-2019

Hi,

I want to calculate no of days by date range.

Please suggest how to do that

v-cherch-msft · ‎02-18-2019

Hi @Anonymous

You may create a measure like below.

Measure = COUNT('Table'[Date])

Regards,

Cherie

Community Support Team _ Cherie Chen
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

v-cherch-msft · ‎02-18-2019

Hi @Anonymous

You may create a measure like below.

Measure = COUNT('Table'[Date])

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎02-18-2019

Hi @v-cherch-msft ,

I am trying to filter on the two date, there are no other date between these two. so can i get no of days difference by filter.

Regards,

Gaurav Manral

Anonymous · ‎02-18-2019

Thanks @v-cherch-msft

BhaveshPatel · ‎02-17-2019

Hi @Anonymous

You can use DATEDIFF function in DAX.

Please see the attached blog post:

https://blog.crossjoin.co.uk/2015/06/22/using-datediff-to-calculate-time-intervals-in-dax/

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.