Forum Discussion

airportplanner's avatar
airportplanner
Frequent Visitor
8 years ago
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...
Need Help
  • NipponSahore's avatar
    NipponSahore
    8 years ago

    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))
airportplanner's avatar
airportplanner
Frequent Visitor
8 years ago

Thank you for your time. Trying to replicate your code i get this

 

NipponSahore's avatar
NipponSahore
Resolver II
8 years ago
if (LEN(Table1[Column]) = 11, right(Table1[Column],5), CONCATENATE(left(Table1[Column],2),RIGHT(Table1[Column],3)))

is the correct function