Another If statement

[therugger2000]

I am attempting extract text from a column based on another column.

Basically if the value from column1 =1, return the first 3 characters in Column 2, if not return rthe first 2.

Example of Column1 info : 1 or 2

Column2 Info: 1234abcd

new=IF Column1="1", LEFT(table1[column2],3, LEFT(table1[column2],2

Any help is appreciated.

[AnkitKukreja · Accepted solution]

Hi! @therugger2000 

Please use the below m code and it should work for you.

Col1      Col2       Extraction

1	123abs	123
2	145grbf	14
3	345	34
1	111ggg	111
2	2334	23
1	2332mmm	233
2	233mmm	23

if [Col1] = 1 then Text.Middle ([Col2],0,3)
else
Text.Middle ([Col2],0,2)