Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a bunch of task that have columns with a completion due date and date closed (among others).
How do I display the number of over due items, but not count the closed items in the process.
Current Method simplfied:
Calc(Sheet(ID), filter(completion<today)filter, sheet(date closed))
I get a number, just not the right number.
Solved! Go to Solution.
I did not try this method, I used the first filter (<TODAY) and then created a second filter with date closed as well and that seems to be working.
Aslo did the same thing for due in 7/30 days., but used TODAY()+7, etc.
Hi @DCS2011 ,
You can use the following DAX formula to display the number of overdue items, but not count the closed items in the process:
Overdue Items =
CALCULATE (
COUNTROWS ( Sheet ),
FILTER (
Sheet,
Sheet[completion due date] < TODAY ()
&& Sheet[date closed] = BLANK ()
)
)
This formula counts the number of rows in the Sheet table where the completion due date is less than today's date and the date closed is blank. This will give you the number of overdue items that are not closed.
Note that the formula assumes that the completion due date and date closed columns are in the Sheet table. You may need to adjust the formula to match the names of your columns.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I did not try this method, I used the first filter (<TODAY) and then created a second filter with date closed as well and that seems to be working.
Aslo did the same thing for due in 7/30 days., but used TODAY()+7, etc.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |