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? Any help would be much appreciated. Thanks in Advance!

  • vicky_'s avatar
    vicky_
    3 years ago

    Try:

    ColumnName = IF([state) in {'Awaiting Info','Open','New'}, "Due_Date")

2 Replies

  • 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.