Forum Discussion
Putting last string element from a column into a new column
Hello, I woud like to create a new column in Power BI desktop that it based on another column in my data. The new column should only take the last string element of the previous column. For examp...
Not sure if you string actually includes the [ and ' symbols, but you can use this formula in a custom column. If you do need those characters, you can concatenate them to the result (or use Replace Values to remove them before or after this step).
= List.Last(Text.Split([ListColumn], ", "))
Pat
Hi Anonymous ,
Please try using the extract function in the query editor.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
Please try using the extract function in the query editor.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.