Forum Discussion
Help convert Excel formula to use in Power Query
Howdy from Texas!
I am trying to do a custom column in Power Query using the following excel formula:
=IF(F2="DORCORE",LEFT(A2,FIND("-C",A2)-1),IF(F2="SURPLUS",LEFT(A2,FIND("-S",A2)-1),IF(F2="CORES",LEFT(A2,FIND("-C",A2)-1),IF(F2="SURPLUS-Z",LEFT(A2,FIND("-SZ",A2)-1),IF(F2="ENGCORE",LEFT(A2,FIND("-C",A2)-1),IF(F2="FORD-S",LEFT(A2,FIND("-F",A2)-1),IF(F2="FORD-SZ",LEFT(A2,FIND("-FZ",A2)-1),IF(F2="BLEMISHED",LEFT(A2,FIND("-Z",A2)-1),A2))))))))
Is it possible to convert this in Power Query and if so, can anyone help me with the code?
Many thanks!!!
Anonymous Power Query if syntax is:
if <condition> then <result> else <result>
You can nest these as much as you want. The equivalent to LEFT is Text.Start function. The equivalent of FIND function is Text.Position function.
1 Reply
Anonymous Power Query if syntax is:
if <condition> then <result> else <result>
You can nest these as much as you want. The equivalent to LEFT is Text.Start function. The equivalent of FIND function is Text.Position function.