Third Result Option Based on a Date Calculation

[PowerBINoob24]

Hello all:

I have the following calculated column in my PoerBI report:

Approval Metric = IF([Approved Date].[Date]>[Due Date].[Date],"Late","On Time")

It works great; however, in some instances there may not be an approved date because the work is still being performed.  Is there any way to add a third option of "In Progress" for those rows taht do not have an approval date yet?

Thanks in advance for helping me with my severe lack of PowerBI knowledge.

[rsbin]

@PowerBINoob24 ,

The SWITCH function in DAX is very similar to using a nested IF function.  Please try something like this:

ApprovalMetric = SWITCH(
                    TRUE(),
                    [Approved Date] = Blank(),"In Progress",
                    [Approved Date] > [Date], "Late",
                    "On Time" )

Hope you can get this to work for you.

Regards,

[JorgePinho · Accepted solution]

Approval Metric = IF(ISBLANK([Approved Date].[Date]), "Being Performed", IF(([Approved Date].[Date]>[Due Date].[Date],"Late","On Time"))

[PowerBINoob24]

This worked like a charm, although you did have an extra parenthesis in your formula.

Approval Metric = IF(ISBLANK([Approved Date].[Date]), "Being Performed", IF(([Approved Date].[Date]>[Due Date].[Date],"Late","On Time"))

[JorgePinho]

I'm glad it worked. The other solution by @rsbin would also work 🙂
And I'm sorry for the extra parenthesis!

[rsbin]

@JorgePinho , @PowerBINoob24 ,

Hence why I have learned to use the SWITCH.  Alleviates the issue with all of those parenthesis.😁

[JorgePinho]

You're right! And it also looks a lot cleaner and easier to read and understand 😀