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 value, so that it can be used as a slicer with all the variable options?

ie IF Date1 &  Date 2 is value then "Complete" is returned. 
IF Date1 has a value & Date2 is blank then "Date2 missing" is returned etc.

 

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

3 Replies