Forum Discussion
Switch Function Replaced Nested IF
Hi guys,
I need help writing nested IF isblank statement.
Here is my currently working dax function but I have another condition that I need to include in this statement.
AgeBracket = IF('Data'[Date1]<31,"0-30 Days", IF('Data'[Date1]'<46, "31-45 Days","45+Days"))
So basically, Current Date minus Date1 if is blank then use Date2. If you look at the last row as an example.
How do I write a proper statement for this logic?
Thank you
| Date1 | Date2 | Age Bracket |
| 6/1/2018 | 8/4/2018 | 45+Days |
| 6/14/2018 | 8/4/2018 | 45+Days |
| 5/13/2018 | 8/8/2018 | 31-45 Days |
| 10/1/2017 | 8/9/2018 | 31-45 Days |
| 8/8/2018 | ?? |
Hi Stuznet,
Try this one, please.
Column = VAR date1 = IF ( ISBLANK ( [Date1] ), [Date2], [Date1] ) VAR days = TODAY () - date1 RETURN IF ( days < 31, "0-30 days", IF ( days < 46, "31-45 days", "45 + days" ) )
Best Regards,
Dale
4 Replies
create on e calculated column
Date = IF('Data'[Date1] = BLANK(),TODAY())
after that apply your function
balaganeshv2201I tried incorporate the formula you provided but I'm getting incorrect syntax highlighted in red.
AgeBracket = IF('Data'[Date1]=BLANK(),TODAY())"0-30 Days", IF('Data'[Date1]<46, "31-45 Days","45+Days"))How do I tell DAX if Date 1 is blank then look for Date2 then give me 0-30 Days, 31-45 Days or 45+Days result? Could you please elaborate or educate me the proper function?
Hi Stuznet,
Try this one, please.
Column = VAR date1 = IF ( ISBLANK ( [Date1] ), [Date2], [Date1] ) VAR days = TODAY () - date1 RETURN IF ( days < 31, "0-30 days", IF ( days < 46, "31-45 days", "45 + days" ) )Best Regards,
Dale
