Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to create a column using nested if statements but I get the following syntax error.
the original formula I want to replicate is:
=IFS(U11<2;"0-2";U11<4;"2-4";U11<6;"4-6";U11<8;"6-8";U11<=10;"8-10";U11>10;">10")
Thanks for help in advance.
Solved! Go to Solution.
Try using "Conditional Column" option in Power Query Editor. It should easily this.
Proud to be a PBI Community Champion
Try to create new custom column in Query Editor, like below.
(IF([COMP SCRAP]<=2) THEN "0-2" ELSE
IF([Comp Scrap]>2 AND [Comp Scrap]<=4) THEN "3-4"
ELSE "")
(IF (U11<2) THEN "0-2" ELSE
IF(U11<4) THEN "2-4" ELSE
IF(U11<6) THEN "4-6" ELSE
IF(U11<8) THEN "6-8" ELSE
IF(U11<=10) THEN "8-10" ELSE
IF(U11>10) THEN ">10" ELSE "")
in DAX you can try wrapping the text in FORMAT function .e.g
FORMAT("0 - 2","")
Try using "Conditional Column" option in Power Query Editor. It should easily this.
Proud to be a PBI Community Champion
Thanks for the quick response. This solved my problem. @PattemManohar I tried using the FORMAT but still got an error. Have you tried it? Thanks
@Anonymous
I couldn't replicate your error, so I assumed FORMAT may help if for some reason your string is not considred text by PowerBI
this code works for me:
Column = IF([Comp Scrap]<= 2, "0 - 2", IF([Comp Scrap] > 2 && [Comp Scrap] <=4, "2 - 4", BLANK() ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |