Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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
Help to Create Dax: applying filter for both Data Type(Text and Date)
Hints & Tips
  • johnt75's avatar
    johnt75
    4 years ago
    Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for the fast reply!