Forum Discussion

qwertzuiop's avatar
qwertzuiop
Icon for Advocate III rankAdvocate III
6 years ago
Solved

create a calculated column that returns a specific string between to numbers

Dear PowerBI Community   First of all: Good luck for 2020!   I have the following question: I want to create a calculated column that returns me a specific string.   IF 0 Break 1 Br...
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi qwertzuiop 

     

    New Column = IF(Customer[Sales] <= 3,"Break",
    IF(Customer[Sales] >3 && Customer[Sales]<22,"No Break","Break")
     
    Thanks & regards,
    Pravin Wattamwar
    www.linkedin.com/in/pravin-p-wattamwar

    If I resolve your problem Mark it as a solution and give kudos.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi qwertzuiop 

 

New Column = IF(Customer[Sales] <= 3,"Break",
IF(Customer[Sales] >3 && Customer[Sales]<22,"No Break","Break")
 
Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.