Forum Discussion
Count distinct rows between two dates
Hi all, I need to create a simple measure that returns the number of rows where the value in a date column falls between two dates. I have had some success, but it only seems to return non-distin...
Hi Anonymous ,
Which part is wrong? According to your description, just change the distinctcount() to count() and it will be fine.
Events in Next 90 Days =
CALCULATE(
COUNT('Table'[Event]),
DATESBETWEEN('Table'[Due Date],Today(), Today()+90)
))
Best Regards,
Jay
Hi Anonymous ,
Which part is wrong? According to your description, just change the distinctcount() to count() and it will be fine.
Events in Next 90 Days =
CALCULATE(
COUNT('Table'[Event]),
DATESBETWEEN('Table'[Due Date],Today(), Today()+90)
))
Best Regards,
Jay