Forum Discussion

James_Galis1's avatar
James_Galis1
Helper II
2 years ago
Solved

Count events on dates based on condition

Hello Community Hoping to get some assistance with the following.   I have a table of contents that has clients attending an event over various dates. I want to count the events but only when t...
Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi James_Galis1 

    You can produce your required output in many different ways and one of them is to create a separate calendar table from the min and max of your date field in your fact table, and then create a relationship with your calendar table and the fact table, and then write a dax formula like below to produce a visual like below.

     

    I attach an example pbix file.  

DataNinja777's avatar
DataNinja777
Super User
2 years ago

Hi James_Galis1 

You can produce your required output in many different ways and one of them is to create a separate calendar table from the min and max of your date field in your fact table, and then create a relationship with your calendar table and the fact table, and then write a dax formula like below to produce a visual like below.

 

I attach an example pbix file.