Passing a Parameter in Power Query

When we transform data using Power Query, every Transformation Step is recorded as an M Code. And most of the time, values got hard coded in these codes. The problem with Hard coding is, when the user decides to change the input data, the Source code (Query in this case) also should be modified accordingly.…

Change Letter Case using Power Query

Like the UPPER, LOWER and PROPER functions we can also use Power Query to convert letters cases. Following is a list of names/words that are written with a combination of upper and lower case letters. To convert these words into UPPER, LOWER or PROPER cases using Power Query, Select a cell in the data set…

Add an Index Column using Power Query

In this blog post, I am explaining an easy method to add a new column to a data set which contains Automatically updating Serial Numbers. Following is the data set to which I want to add a new column of Serial Numbers. To add a column of Automatically Updating Serial Numbers to this data, Select…

Group Data using Power Query in Excel

Group By feature in Power Query help us to group or summarize data from different Rows on the basis of a condition or conditions. Following is a sample Sales data from which I want to create a summary report. The data contains the sales amount for 3 products Snickers, Bounty and Galaxy for 4 different…

Transpose Data using Power Query in Excel

We can use either the TRANSPOSE function or the Paste Special Transpose option to transpose data in Excel. Here is one more method to transpose data, which is using the Power Query in Excel. Following is the data which is I want to Transpose. To transpose this data using Power Query, Select a cell in…