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

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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

    • bikram_laishram's avatar
      bikram_laishram
      Helper I
      8 years ago

      Hi Dale,
      v-jiascu-msft
      I have one more table(Job order) in the same report which has a date column and three other columns, which contain ID (foreign keys). I need to have a distinct count of these ids to calculate a frequency based on the same slicer selection. Now the vessel table and job order tables are linked to get a count of breakdown jobs and planed jobs. Since I can not have any relationship between the vessel table and calendar, do you think it will be possible to still get a unique count using the calendar table

      Best regards,

      Bikram