Forum Discussion
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_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?
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
2 Replies
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
Awesome, thanks!
