Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey guys,
I have a column of "Charge Description," and would like to shorten the text in the column.
It looks something like this:
Shop(1) - 1st Checked Bag
Shop(2) - 1st Checked Bag
Shop(5) - 1st Checked Bag
Shop(3) - 1st Checked Bag
Shop(10) - 2nd Checked Bag
Shop(9) - 2nd Checked Bag
and so on.
It there a way to remove all of the Shop() values, and hyphens (leaving only 1st Checked Bag, 2nd Checked Bag, etc.), in one step?
Have been googling for a while now and can't seem to find an answer.
Tried something similar to this but no success yet, because it's not entirely correct, I'm sure -
List.Transform([GL Charge Description], each Text.Contains((FindStrings[GL Charge Description]),-))
Any help is appreciated. Thanks 🙂
Solved! Go to Solution.
Nevermind! I have it! Just simply split the column by number of characters!
Nevermind! I have it! Just simply split the column by number of characters!
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |