Forum Discussion
Backlog Measure
Hi All,
Could you help me with a backlog measure please, i wish to count all the Task ID's which have a date before today.
Columns -
Task ID -
Task Due Date
Thanks
Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())
2 Replies
Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())