Switch Function Replaced Nested IF

[Stuznet]

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	??

[balaganeshv2201]

create on e calculated column 

Date = IF('Data'[Date1] = BLANK(),TODAY())

after that apply your function

[Stuznet]

@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? 

[v-jiascu-msft · Accepted solution]

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

[Stuznet]

Thank you so much for youe work 🙂