Forum Discussion

Giada90's avatar
Giada90
Icon for Helper IV rankHelper IV
4 years ago
Solved

formula in power query editor

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
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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