Forum Discussion
Helper IIIGet Daily count measure
Hopefully this is an easy and straightfoward question. I have a huge amount of data that is sliced by using dates between a start and end date. I want to have a table showing the date(s) and a COUNT of how many work orders have a record on that date. What would be the DAX for this?
Thanks
3 Replies
- amitchandak
Super User
v-zhangtiCommunity Support
Hi, CMSGuy
You can try the following methods.
Sample data:
Create a new date table.
Table:
Date = CALENDAR(MIN('Table'[Start]),MAX('Table'[End]))Measure:
Count = CALCULATE ( COUNT ( 'Table'[Event] ), FILTER ( ALL ( 'Table' ), [start] <= SELECTEDVALUE ( 'Date'[Date] ) && [end] >= SELECTEDVALUE ( 'Date'[Date] ) ) )Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CMSGuyThis is somewhat getting there, except my table just has a date (no start, end). I am using a slicer with the between dates function, however I believe I can work with what you gave me and I appreciate it.