OR Statement ?

[ArchStanton]

Hi,
I have this DAX code that needs one more condition which is that if Resolution Date ISBLANK then BLANK().

No of working days = 
VAR Start_Date = SELECTEDVALUE('Cases'[Created On])
VAR End_Date = SELECTEDVALUE('Cases'[Resolution Date])
VAR Network_Days = NETWORKDAYS(Start_Date,End_Date,1)
RETURN
IF(Network_Days = 0,Network_Days +1, 
    Network_Days)

Where can I add this extra condition?

[quantumudit · Accepted solution]

Hello @ArchStanton 

You can use nested IF statement in DAX as follows:

No of working days =
VAR Start_Date =
    SELECTEDVALUE ( 'Cases'[Created On] )
VAR End_Date =
    SELECTEDVALUE ( 'Cases'[Resolution Date] )
VAR Network_Days =
    NETWORKDAYS ( Start_Date, End_Date, 1 )
RETURN
    IF (
        End_Date = BLANK (),
        BLANK (),
        IF ( Network_Days = 0, Network_Days + 1, Network_Days )
    )

Best Regards,
Udit

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍

🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree

Proud to be a Super User

[ArchStanton]

Awesome, thanks!