Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Column [Status] has either Completed, Overdue, or Coming Due
I want to create a new column named Days Overdue that only uses Overdue from the Status Column
If it is Overdue, then count the days between TODAY and the [Due Date]
If Completed or Coming Due, leave it blank.
Thank you!
Solved! Go to Solution.
@racheljeska
add below calculated column to achieve this:
Days_Overdue = IF( [Status] = "Overdue", MAX(0, DATEDIFF(TODAY(), [Due Date], DAY)), BLANK() )
Learn Power BI free:
Hi @racheljeska
Try this:
DaysOverdue =
IF ( [Status] = "Overdue", DATEDIFF ( TODAY (), [Due Date], DAY ) )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @racheljeska
Try this:
DaysOverdue =
IF ( [Status] = "Overdue", DATEDIFF ( TODAY (), [Due Date], DAY ) )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
@racheljeska
add below calculated column to achieve this:
Days_Overdue = IF( [Status] = "Overdue", MAX(0, DATEDIFF(TODAY(), [Due Date], DAY)), BLANK() )
Learn Power BI free:
The Due dates are in the past
But that new column is saying 0 for Over due days
I took out
MAX(0,
And I think it works now. Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
69 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
28 | |
24 | |
24 |