formula in power query editor

[Giada90]

Hi,

I need to make this column in power query editor because I need to use it in a join.

The formula is this:

Column = SWITCH(TRUE(),

MID(VGOP14_SAP_DSH[Codice WBE/CdC],7,5)="C00.0" && VGOP14_SAP_DSH[Area Attività] ="50", "C00.0",

MID(VGOP14_SAP_DSH[Codice WBE/CdC],7,5)="C00.1" && VGOP14_SAP_DSH[Area Attività]="50", "C00.1",

MID(VGOP14_SAP_DSH[Codice WBE/CdC],7,5)="ik0.0" && VGOP14_SAP_DSH[Area Attività]="33","IK0",

"")

If I put this formula in a column in power query editor it gives me an error, how can I change it?

Thanks

[amitchandak · Accepted solution]

@Giada90 , try like this

Column = if
Text.Middle(VGOP14_SAP_DSH[Codice WBE/CdC],6,5)="C00.0" and VGOP14_SAP_DSH[Area Attività] ="50" then "C00.0"
else if
Text.Middle((VGOP14_SAP_DSH[Codice WBE/CdC],6,5)="C00.1" && VGOP14_SAP_DSH[Area Attività]="50" theh "C00.1"
else if
Text.Middle((VGOP14_SAP_DSH[Codice WBE/CdC],6,5)="ik0.0" && VGOP14_SAP_DSH[Area Attività]="33" then "IK0"
else
""

Power Query - Text.Start, Text.Middle, Text.End: https://www.youtube.com/watch?v=vky4wPqm0O0

[Giada90]

Thanks