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:
Join the group BI Simplified to stay updated on future webinars and articles.