BI Simplified Webinar# 1, p3: Text Transformations using Power Query

Dimensions play a vital part in the analysis. Text transformations help in simplifying the effort required to perform tasks like:

· split data into multiple columns using delimiter or certain text length,

· merging two or more columns,

· removing unwanted spaces and characters using TRIM & CLEAN,

· extracting specific texts or numbers from a column & more.

All of this is a simple task in Power Query. This segment of the webinar highlights a few such features.

Related article:

Text transformations using Power Query

Join the group BI Simplified to stay updated on future webinars and articles.