Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello friends.
I need help with this challenge. I'm having trouble thinking of a solution. I need to extract from this column a certain sequence of numbers, example:
pls try this
Text.BeforeDelimiter(
Text.BetweenDelimiters(
[input], """:"" -","//"),"-")let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("7VSxboMwFPwVRNeE2AZj3K2VMjYdki1ElrFNYyXBqW3Soeq/1zWBpZ8QGBC6u3c6PU5vv0+/6/SoparT5zr1tg8fizp1R2M9k8oJq69emy7SHCZeOT8olL1pMYyVtK0w4lI2sAjvAjouuYANhrCgJaRwMO2ZVWfulWSeu5OLo5Gw6rMPvoFojQ2ii7nxc6RBDjAQNIeNQFJAQB1HmOQVIaDFRSMa2t6tJfeciTN3Trda8Cmz7ryyHfsy9hTMxZAkqPrOGwZA1CTLBOcYZxDlBS5JhmCGAoaGJ1mtksCQihYljuPDXqZxmsEMlmFgBKKImauyMccIb9/Qy2vkPqzpryO8W29375v1EMyjEeb/1uz15R5/ctw+LXMQsauZ8lSUUBpB49jfSvmF6S44aRmAjjM3KjemTn/Sw2JuwdACRCuSgakGYK7BQ9ZgPgZzC0ILChL+Pq5IAcNRwHMLHrIFJajAw96Cwy8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [input = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"input", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Text.BeforeDelimiter(
Text.BetweenDelimiters(
[input], """:"" -","//"),"-"))
in
#"Added Custom"post some lines to help you. Can't copy text from image
Thanks for the contribution. Could you be more specific? Is the image not complete? grateful
just give an excel file with a few lines words
Here is the excel file with some examples. Thanks
Hello
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 67 | |
| 45 | |
| 41 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 191 | |
| 127 | |
| 106 | |
| 78 | |
| 53 |