Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this…
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’ and end with ‘*/’. Comment…
Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions…
Learn How to Manage Parameters in Power Query Step-by-Step. [toc] Power Query can create a query parameter and link it to the…
One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename…
Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily…
You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together….
Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the…
Steps to Create Grouped Serial Numbers in Power Query. If we have data for products and we want a unique identifier for…
The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is…
Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When…
Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be…
If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because…
Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of…
Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you…
Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the…
Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim,…
While using Power Query, you might’ve come across a step that reads ‘Navigation’ in Applied Steps pane and it is automatically created…
Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a…