Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey All,
Got stuck with the syntax.
I want to replace values in a column.
Replace all values from a column where value not starting with specific text.
How can I do it?
#"Replaced Value" = Table.ReplaceValue(#"Added Custom Column",each if [Custom] <> Text.StartsWith([Custom], "day=""") then "" else "bla",Replacer.ReplaceText,{"Custom"})
Cheers!
A
Hello @Anonymous
What about doing it in a new custom column?
= Table.AddColumn(#"Renamed Columns", "New column", each if Text.StartsWith([Custom], "day=""""") then "" else [Custom])
Then just delete the old column and rename the new one.
Thats not a bad idea.
That is already a new custom column which I want to clean from leftovers.
But, I can do it. Create a new column and then maybe delete the original custom column.
Thnaks,
A
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |