Forum Discussion

JedShields's avatar
JedShields
Regular Visitor
2 years ago
Solved

Looking for help with IF AND statement mixing dates and text

Hello all,   I'm fairly new to DAX and need some help with the following code: MS7 FC Exception =         IF(ISBLANK([Column A DATE])         && [Column B DATE] >= 1         && [Column C ...
Need Help
  • manvishah17's avatar
    manvishah17
    2 years ago

    Hi JedShields ,
    MS7 FC Exception =
    IF(
    ISBLANK([Column A DATE]) &&
    NOT(ISBLANK([Column B DATE])) &&
    NOT(ISBLANK([Column C DATE])) &&
    [Column D TEXT] = "No",
    "Issue",
    "No Issue"
    )

manvishah17's avatar
manvishah17
Icon for Solution Supplier rankSolution Supplier
2 years ago

Hi JedShields ,
MS7 FC Exception =
IF(
ISBLANK([Column A DATE]) &&
NOT(ISBLANK([Column B DATE])) &&
NOT(ISBLANK([Column C DATE])) &&
[Column D TEXT] = "No",
"Issue",
"No Issue"
)

JedShields's avatar
JedShields
Regular Visitor
2 years ago

Excellent, many thanks.  NOT ISBLANK is a much better way of writing it 🙂