Forum Discussion
James_Galis1
Helper II
Helper IICount 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...
pls try this
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.
Ahmedx
Super User
Super Userpls try this
James_Galis1Helper II
Helper IIThank You
This works best for how i wish to present the data
Many thanks