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 Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List…
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…
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,…
How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it…