Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())
Thank you for the fast reply!
Backlog = CALCULATE( DISTINCTCOUNT( 'Table'[Task ID]), 'Table'[Task Due Date] < TODAY())
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
13 | |
12 | |
9 |