Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need to make this column in power query editor because I need to use it in a join.
The formula is this:
Solved! Go to 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 , 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
Thanks
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |