Forum Discussion
Solved
OR Statement ?
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_...
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: LinkTreeProud to be a Super User
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
Awesome, thanks!