Forum Discussion

laurahoff's avatar
laurahoff
New Member
2 years ago
Solved

How to get a true/false column based on two other date columns

Hello,   I am attempting to add a column (titled 'active') that will be true/false data type based on if today's date is between the start and end date columns. For reference here are some data poi...
Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try

    Active = IF('Table'[Start dar]<=TODAY() && 'Table'[End Date]>=TODAY(),TRUE,FALSE)

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

pls try

Active = IF('Table'[Start dar]<=TODAY() && 'Table'[End Date]>=TODAY(),TRUE,FALSE)

dmf's avatar
dmf
Frequent Visitor
2 years ago

May I ask, what if the second column is in a different table. How would you write the comparison then?

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    you need to merge them or move the second column one to the first table