Help Needed with Calculated Column.

[vashu-123]

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_ · Accepted solution]

Try:

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

[vashu-123]

@vicky_ Thank you very much. It Worked.