Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everyone!
One column in Power Query has two types of values:
A 73 digit and a 8 digit values. End result must be 8 digit, 10016711 and 10016709. How to extract or clean up the 73 digit values starting with PO: ?
Solved! Go to Solution.
Thanks for the info, here is my suggestion for the output, would love to see others alternatives.
test is the column name I was trying
steps
I created a Custom Column on PowerQuery, but you can also add this directly on Source
if Text.StartsWith([test], "PO")
then Text.RemoveRange(
(Text.RemoveRange(Text.From([test]),0,4)),
8, Text.Length([test])-12
)
else [test]
Please check if works, hope it was helpful.
Regards,
Douglas.
Thanks for the info, here is my suggestion for the output, would love to see others alternatives.
test is the column name I was trying
steps
I created a Custom Column on PowerQuery, but you can also add this directly on Source
if Text.StartsWith([test], "PO")
then Text.RemoveRange(
(Text.RemoveRange(Text.From([test]),0,4)),
8, Text.Length([test])-12
)
else [test]
Please check if works, hope it was helpful.
Regards,
Douglas.
Hi @tmyasoutov ,
I don't know for the others, but for me it's quite confusing your expectations just with this image.
Could you please create like 3 fake example something like this, it'll be very helpful
Actual value | Expected final value |
ABC333333ABC | 333333 |
ZYX999999ZXC | 999999 |
Regards,
Douglas.
Hey @dcrosseto ! Apologies for the confusion, here's how it looks like in the slicer:
Really long out of place lines, where I only need the 1001XXXX numbers at the start, rather than the whole line!
10016710 |
PO: 10012174 A9B: XXXXXXXXXXX Desc: XXXXXXX_XX_XXX_XXXXX-XXXXXX_XXX WBS: |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |