Forum Discussion
Stuznet
Helper V
Helper VSwitch 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 = I...
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
create on e calculated column
Date = IF('Data'[Date1] = BLANK(),TODAY())
after that apply your function
Stuznetbalaganeshv2201I 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-msftMicrosoft Employee
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 :)