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 "O...
  • BjoernSchaefer's avatar
    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