Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

date difference by date filter

Hi,     I want to calculate no of days by date range. Please suggest how to do that
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

     

    You may create a measure like below.

    Measure = COUNT('Table'[Date])

     

    Regards,

    Cherie

     

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

 

You may create a measure like below.

Measure = COUNT('Table'[Date])

 

Regards,

Cherie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks v-cherch-msft 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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