How to Extract Numbers from Text using power Query in PowerBI | MiTutorials

preview_player
Показать описание
How to Extract Numbers from Text using power Query in PowerBI | MiTutorials
PowerBI Tutorial for Beginners
Рекомендации по теме
Комментарии
Автор

Solution #1 is REALLY helpful, and very simple compared to the solutions proposed in the Microsoft supported blogs. Thank you!

livioazzoni
Автор

can we do it with a transform instead of with a create new column?

Edit: Found it already.
= Table.TransformColumns( #"PreviousStepName", {{"Column", each Text.Select( _, {"0".."9", "-", "."} ) }} )

H-HQ