PowerQuery QuickBytes # 4 - Text transformations simplified
In any analysis, along with the numbers, text plays an important part. They create dimensions for the data, which helps in creating multiple perspectives. Texts also help in grouping the data into different categories and hence quite handy during analysis.
Power Query has some great alternatives for native Excel formulas like CONCATENATE, LEFT, RIGHT, MID, UPPER, PROPER, LOWER, and Text to Column feature. This video explores how we can replace these formulas with simple mouse clicks.