cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
erhan_79 Frequent Visitor
Frequent Visitor

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

c5.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
BjoernSchaefer Regular Visitor
Regular Visitor

Re: DAX formula help

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 2
BjoernSchaefer Regular Visitor
Regular Visitor

Re: DAX formula help

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 Frequent Visitor
Frequent Visitor

Re: DAX formula help

thanks @BjoernSchaefer it is working