Power Query Editor: How to extract numbers only from an Alphanumeric Column in Power BI
#Achieversdataengineering #powerbi #powerbitutorial #dax #learnpowerbi
In this video, we have discussed in detail about how can you extract numbers only from an Alphanumeric or Text column in Power BI while working in Power Query Editor.
Thank you for watching!
If you like the content, Please don't forget to subscribe to my YouTube channel
To Remove Alphabets only - Text.Remove([ColumnName],{"A".."Z"})
To Remove anything and retain numbers only -
Text.Remove([ColumnName],
Text.ToList(Text.Remove([ColumnName],{"0".."9"})))