Help needed for 'Overdue Items' in Power BI

Question

I am working on creating a report that will show any items that are due past a certain due date. I am hoping to create either a measure or a new column with this info.

The columns I need to use to get this data is:

Action Due Date : This has the date that the item is due by.
Closed Date: The date that the item was closed on.
Status: This shows if the item is 'complete' 'ongoing' or 'not started'

I need the logic to be = If item is not 'complete' then check the Action Due Date by the Closed Date to see if it is overdue, and then mark it as maybe 1? and if its not due yet, then mark as 0?

Not sure how to go about this, would appreciate any help!

Answer 1

Hi anonymous user-0401,

Please note that Power BI is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products.

You may ask the experts in the dedicated Power BI forum over here:
https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

----------

If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

Best regards,
Leon