Forum Discussion

erhan_79's avatar
erhan_79
Post Prodigy
7 years ago
Solved

DAX formula help

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

 

Need Help
  • BjoernSchaefer's avatar
    BjoernSchaefer
    7 years ago

    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

2 Replies

  • BjoernSchaefer's avatar
    BjoernSchaefer
    Helper II
    7 years ago

    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