Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost 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...
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

BjoernSchaefer's avatar
BjoernSchaefer
Icon for Helper II rankHelper 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