fbpx

Tag

Power BI

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

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 Step 1:...
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 in 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

Split First & Last Name Using Power Query

Sometimes, when you have a data table which includes full names of candidates in one column and you want to separate the full name into first name and surname in different columns. Split First & Last Name With Power Query This is a common task, but most people may use complex formulas to perform this...
Read More

Learn How to Replace Values in Power Query

There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace any value with the new value you provide into your data table. You may go through step by step procedure where our Power Query Training expert has explained the topics in a detailed manner with...
Read More

Steps to Format Columns Using Power Query

Another important feature of Power Query is Format Columns. There are various formatting options available in Power Query for columns like Trim, Clean, Add Prefix, Uppercase, etc. In this example, we are going to see how to capitalize each word from the column using the formatting feature. Format Columns By Power Query Step 1: Select...
Read More

How to Navigate Query Editor Using Power Query

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for? Navigate Query Editor Using Power Query The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data] This is one of the ways...
Read More

How to Edit A Query Using Power Query

Power Query also allows you to edit a query that you have already generated. Let’s take an example. Suppose you have a data table as shown below. Editing A Query By Power Query This is an employee data and you have to create the post for each employee based on their experience given in the...
Read More

Delete Steps Until End By Power Query

If you want to delete some steps, you can do it in one shot. The Power Query Delete Until End feature helps to delete as many steps up to the end in one click. Delete Steps Until End By Power Query Let us understand this feature with the help of an example. Step 1: Load...
Read More

Data Type Conversion With ‘M’ Using Power Query

Data Type Conversion With ‘M’ with Power Query. Sometimes it happens that the things we want to do are not built in the user interface.  But Power Query’s programming language M has made this possible. Data Type Conversion With ‘M’ Using Power Query One of the unique functionality of M is that it takes data types very...
Read More

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

How to Extract Right Side Data form Excel? If we want to use Excel’s RIGHT Function, it is not possible as it is not supported in M. But we can use the RIGHT Function in M in other way using Power Query and the Text. End formula! Use Excel’s Right Function With M To Extract...
Read More

Replicating Excel’s Find Function With ‘M’ in Power Query

In the above example, you learned how to concatenate the columns using the M language. Unfortunately, not all of the Excel’s formulas can be used in M query. Replicating Excel’s Find Function With ‘M’ Using Power Query For instance, if we want to use Excel’s FIND function to find a specific character in the text,...
Read More
1 2 3