Forum Discussion
Trim Function
I wanted to delete specific strings from the data. But the data is not consistent. sample data 123456_1 123456_10 1234568_01 1234567_1 I need to remove the last strings ( which are highli...
Anonymous , you can split column based on _
https://docs.microsoft.com/en-us/powerquery-m/text-split and use only first item on list
Try this
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/