Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

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 = I...
Need Help
Show and Tell
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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" ) )

    Nested_IFs_ISBLANK_Then_Use_Other_Value

     

    Best Regards,

    Dale

balaganeshv2201's avatar
balaganeshv2201
Frequent Visitor
7 years ago

create on e calculated column 

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

after that apply your function