Forum Discussion
Solved
IF statement with LEN, LEFT & RIGHT formulas
Hello, new to Power Bi, sorry if this is a basic question. I have a column with 2 types of data (lets call it Flight No Colunn) : BA254/BA879 and BA463/548 I have created a helper column that...
i only changed the position of the parentheses
Column 2 = IF(LEN(Table1[Flight No Column]) =11, RIGHT(Table1[Flight No Column], 5), CONCATENATE(LEFT(Table1[Flight No Column], 2), RIGHT(Table1[Flight No Column], 3))
Can you provide an example of the output you are looking for in both scenarios (LEN 9 and 11). I ran your code, adding the appropriate () and this is the result:
Thank you for your time. Trying to replicate your code i get this
if (LEN(Table1[Column]) = 11, right(Table1[Column],5), CONCATENATE(left(Table1[Column],2),RIGHT(Table1[Column],3)))
is the correct function
With the above code, I can not go to the second step of the if command as shown here:
I am still failing to write down the correct syntax.
Can i kindly ask you to upload your functional Power Bi file?
