Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
Series: Power Query Transform
Power Query Transform Phone Number
Do you need to split a column of imported Excel telephone number data into two columns so that […]
Text Transformation in Power Query
This post covers a few common text transformations in Power Query. When you are working with a column, […]
Split Column by Delimiter
In Power Query transformations, the split column by delimiter has something that you need to be aware of. […]
Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
Number Transformations
Number transformations in Power Query are simple to do, but there is something you need to watch out […]