Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

convert true / false to date

I want to write this  dax  query to return  date column, does any one know how i can convert it to a date column?

DigFilter = 'worker'[date]
            <= TODAY() + 30
Need Help

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi Anonymous 

    try to add a calculated column like:

    column =
IF(
    [date]<=TODAY(),
    [date]+30,
    [date]
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      i tried this but my columns shows date going all the way back to 1900? as shown on this screenshot, any suggestions on what the issue is