Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Working with a column in Excel that contains:
UA56551325295214354/U2/8414259/9906589-LINE36
Currently working with: =Text.Split([PO],"/") to create a List value.
Next step is to determine which record in the List starts with "U" and is a minimum of 14 characters long. Once identified show that value in cell.
Not sure how to continue.
Thank you in advance.
Solved! Go to Solution.
=List.Select(Text.Split([PO],"/"),each Text.StartsWith(_,"U") and Text.Length(_)>13){0}?
Wdx, Thank you so much!
=List.Select(Text.Split([PO],"/"),each Text.StartsWith(_,"U") and Text.Length(_)>13){0}?
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 19 | |
| 14 | |
| 12 | |
| 10 | |
| 8 |