Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated column for date comparison

Hello, I have the folllowing table and i am trying to add a calculated column with output based on: 1. If Start date <= End date, output: Valid dates 2. If Start date > End date, output: Invalid d...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Status CC =
SWITCH (
    TRUE (),
    ISBLANK ( Data[Start date] ) || ISBLANK ( Data[End date] ), "Missing dates",
    Data[Start date] > Data[End date], "Invalid dates",
    Data[Start date] <= Data[End date], "Valid dates"
)
Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
3 years ago

Check This one

Calculated Column=IF(Start date <= End date,"Valid dates",
IF(Start date > End date,"Ivalid Dates",IF(And(Start date=Blank(), End date=Blank()),
OR(Start date=Blank(), End date=Blank())