fbpx

Category

Tutorials

Learn How to Display A Monospaced Font in Power Query

Normally data is viewed in the Unicode Font for any kind of data. But do you know you can also change this font to a monospaced font? With 3 easy steps, you can quickly display a monospaced font with Power Query. For more Power Query Tips & Tricks you can check our highly appreciated Power...
Read More

How to Add Comments In M Using Power Query

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 plays an important role to understand the code. In the future, if you want to change some part of code or want to share your code with your friend, who can easily understand...
Read More

Top 5 Steps to do Comments In Query Steps – Power Query Tutorial

Learn How to do Comments in Query Steps with Power Query. The new feature of Power Query allows you to add descriptions to each step in the Applied Steps pane. The step descriptions become comments in the M code in Power Query. If you write M code in the Advanced Editor window, then your comments appear...
Read More

Steps to Create A List Query From A Table Column

Power Query also allows you to create a list query from a data table available. The column from the given data table can be used to create a list query. This can be explained with the help of an example. Creating A List Query From A Table Column Here, we have a data table containing...
Read More

How to Manage Parameters in Power Query

Learn How to Manage Parameters in Power Query Step-by-Step. Power Query can create a query parameter and link it to the List Query. This is one of the most unknown features of Power Query. Let us study this unique feature along with an example. We have considered the same example of the list query explained...
Read More

Learn How to Rename A Column Using Power Query

One of the important and most needed features of Power Query is the Renaming Column Headers. Many people facing issues to rename column names using Power Query. We show you step by step process, how you can rename a column in Power Query very easily. To get in-depth knowledge related to Power Query and its...
Read More

Learn How to Merge Columns in Power Query

Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily by following below steps. Merge Columns in Power Query   Step 1: Select the Columns in Power Query for Merging If you have a data table as shown below and you want to...
Read More

Top 3 Steps to Append Queries Using Power Query

You can even append queries in Power Query. This feature is very useful if you want to combine two data tables together. Let us understand this using an example. As shown in the below picture, you have two sales data for the years 2015 and 2016. We want to combine these two data tables together....
Read More

Top 5 Steps to Extract Age Using Date in Power Query

Learn How to Extract Age using Date in Power Query. This is an amazing feature as it allows you to extract the age out of the date provided. Let us elaborate on this feature using an example. There are more similar functions that are very much useful in Power Query for Data Cleaning and Data...
Read More

How to Create Grouped Serial Numbers In Power Query

Steps to Create Grouped Serial Numbers in Power Query. If we have data for products and we want a unique identifier for each product name in the list. But as you can see below each product appears multiple times in the data table. Create Grouped Serial Numbers In Power Query But we want to keep...
Read More

How to Create A Sequential List Using Power Query

The Power Query M language allows you to create a list containing a sequence of numbers or characters very easily. This is possible when you are defining lists by using expressions in the format- To get in-depth knowledge about Power Query and its functions, check our latest high rated Power Query Course and become a...
Read More

Disable Relationship Detection for Beginners in Power Query

Disable Relationship Detection for Beginners in Power Query. This is another feature of Power Query that will speed up your queries. When you load your data into the data model from the power query, Excel will try to find and build relationships between the new data and other tables in the present in the data...
Read More

Advanced Editor With Power Query

Advanced Editor With Power Query can perform a lot of complex steps with any kind of data source. However wouldn’t it be fun unless you understand what is happening under the cover? This Power Query Tutorial will help you to understand how to use Advanced Editor. These complex steps are well explained by our Power...
Read More

Text To Column in Excel | Split Cells

TEXT TO COLUMNS To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names. How to splits cells into multiple columns To use text to a column in excel, please follow below...
Read More

Alteryx for Beginners – Alteryx Online FREE Course

Alteryx for Beginners Course is designed for the people who hardly know about Alteryx or how it can be used. We have kept in mind this type of Audience of ours who are the first-time users of technology beyond MS Excel. For them, MS Excel is the solution to all things. Check out What is...
Read More

How to Use Text to Columns in Excel

Do you know what Text to Columns is feeling right now? It is feeling sad and unappreciated. It is because it gets less credit than it actually deserves. Text to Columns in Excel is one of the most wonderful features in Excel. Here in this tutorial, you’ll learn about the various things you can do...
Read More

Use Excel’s Right Function With ‘M’ To Extract Left Side Data

If you want to use the Excel LEFT Function in Power Query, then you can’t directly go for it. This is because the Excel LEFT Function is not supported in M. To get in-depth knowledge related to Power Query and its functionality then Check Our Latest Power Query Course with 24×7 online support and lifetime...
Read More

Get The Length Of Strings Using ‘M’ in Power Query

Get the Text Length using Power Query M. If we want to use the Excel LEN function to get the length of strings, it is not supported in M. Let us see how to use the LEN Function in M to get the length of strings. Get Text Length Using ‘M’ Power Query Follow the...
Read More

Best Ways to Add Column From Examples in Power Query

Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you can easily do it using Add Column from Examples feature. If you want to learn more tips & tricks then you can check our high rated Power Query Course. This training provides excellent...
Read More

Best Ways to Import Data From XML in Power Query

You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an Excel spreadsheet? For that, you have to follow these following steps, suggested by our Power Query Training Experts. Each step is well explained with image visualization. Import Data From XML Using Power Query...
Read More
1 7 8 9 10 11 16