DAX formula help

[erhan_79]

Dear All ;

İ need a simple support as below

I have a column  as named with Qty ,  , i want to create a new column named " Description" and when the "QTY" column is "0" , it will be written "OPEN"  on "Description"  column, if not it will be written "Closed" as below table.

thanks in advance for your kind supports

[BjoernSchaefer · Accepted solution]

Hi @erhan_79,

this should work:

Description = IF([Qty]=0;"Closed";"Open")

Please be aware that, regarding your Language Settings, you have to use "," instead of ";". Let me know if it worked for you.

Regards

BjoernSchaefer

[erhan_79]

thanks @BjoernSchaefer it is working