Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help Needed with Calculated Column.

Hi All. Below i am pasting a SQL statement:   "case when state in ('Awaiting Info','Open','New') then Due_Date"   How do i write DAX for calculated column according to the SQL statement above? An...
  • vicky_'s avatar
    vicky_
    3 years ago

    Try:

    ColumnName = IF([state) in {'Awaiting Info','Open','New'}, "Due_Date")
vicky_'s avatar
vicky_
Super User
3 years ago

Try:

ColumnName = IF([state) in {'Awaiting Info','Open','New'}, "Due_Date")
Anonymous's avatar
Anonymous
Not applicable
3 years ago

vicky_ Thank you very much. It Worked.