Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DCS2011
Helper I
Helper I

Displaying count of overdue task

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. 

1 ACCEPTED 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.

View solution in original post

2 REPLIES 2
v-rongtiep-msft
Community Support
Community Support

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.