Forum Discussion

bikram_laishram's avatar
bikram_laishram
Helper I
8 years ago
Solved

Custom Count from a date range

  Hello Folks,   Merry X'mas & Happy New year.   I have a table where we have two date columns i.e. "from Date" and a "to date" column. How do I create a DAX measure or query to get count of ves...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi bikram_laishram,

     

    Did you try out my solution? It should work. You need a time line slicer from the Store. Please check the file here. (don't create relationship between two tables).

    Custom_Count_from_a_date_range2

     

     

    Best Regards,

    Dale

     

     

bikram_laishram's avatar
bikram_laishram
Helper I
8 years ago

Hi Dale, 

 

At the cost of soudning like an village idiot, I am sorry I had added a relationship between the two tables and hence was not able to achieve the desired result. As soon as I deleted the relationship it worked like a breeze. 

 

Hope you didn't have to spend too much time on this. 

 

Thank you once again.

 

Merry XMas once again and have a great year ahead

 

Regards

 

Bikram

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Bikram,

 

My pleasure. It's because the relationship will filter down the records that we don't create a relationship. I'm glad you can get it work. Merry Christmas and Happy New Year.

 

Best Regards,

Dale