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))
NipponSahoreunfortunately your code is not working
I can not replicate the working example from BKirsch12
I am uploading my file, would you mind taking a look ?
https://drive.google.com/open?id=1Tki-_fl_X6HqY2Ea9bV4fV-Je_nxEzQP
The error I am getting is this one:
The problem is the LEN function. This is what you had in the file you sent:
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)))
The length (LEN) function needs to return a value before it can be compared to another number. This is how it should be:
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)))