Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Columns using nested IF and NOT(ISBLANK) returning text value

Hi, I have two date columns and I am trying to create a calculated column depending on the combination of these two colums. Is there anyway to create them as a nested statement, that returns a text ...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Like this?

    CalcCol =
SWITCH (
    TRUE (),
    ISBLANK ( Table1[Date1] ) && ISBLANK ( Table1[Date2] ), "Both dates missing",
    ISBLANK ( Table1[Date1] ), "Date1 missing",
    ISBLANK ( Table1[Date2] ), "Date2 missing",
    "Complete"
)
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Like this?

CalcCol =
SWITCH (
    TRUE (),
    ISBLANK ( Table1[Date1] ) && ISBLANK ( Table1[Date2] ), "Both dates missing",
    ISBLANK ( Table1[Date1] ), "Date1 missing",
    ISBLANK ( Table1[Date2] ), "Date2 missing",
    "Complete"
)