IF source = 'x' then ELSEIF source = 'y' then

[samerhaidar0811]

Hey guys,

Consider the below sample data:

source	A	B	MK
x	AZ~ER_MK~PK_PR~PAXF_CN~SC		PK
y		YQ~21Q3_CA~eComNoneCom_MK~TR_CP~987	TR

I need to write an if else conditon which does the following:
if source = x then i need to extract the letters between _MK~  and the following _ from column A

else if source = y then i need to extract the letters between _MK~  and the following _ from column B

The result should be the custom column (MK) as shown in the table above.

Apprecitate your support!

[AntonioM · Accepted solution]

Hi @samerhaidar0811 

You could use this step in Power Query to create the column

= Table.AddColumn(#"Changed Type", "MK", each if [#"source "] = "x" then Text.BetweenDelimiters([A], "_MK~", "_") else if [#"source "] = "y" then Text.BetweenDelimiters([B], "_MK~", "_") else null)

[samerhaidar0811]

Thanks @AntonioM !