How to use power query concatenate function? There are times when we want to perform such tasks that are not built in the user interface i.e. features that are not available on the ribbon. But still, this can be possible with Power Query’s programming language which is called M language.   Power Query Concatenate Data/Text...Read More

Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an example with the picture is given below.   Transposing Data By Power Query Let’s go through the steps in detail for transposing data. Step 1: Open the data in Power Query Open the...Read More

Power BI is a self-service BI analytics and visualization tool. As the business data is increasing, it is becoming impossible for tools like MS Excel to handle the huge amount of data and carry out all the analysis functions. Thus, most of the times analysts have to rely on incomplete data to perform analytics. Incomplete...Read More

In this article, we will discuss the Doughnut Chart in Power BI. A doughnut chart is the same as a Pie chart the only difference is that is has a hole in it like a doughnut. It is used to determine the relationship of the part to a whole. The blank space in between can...Read More

In this article let us understand the Bar & Column Charts in Power BI visualization. One of the most common ways of visualizing the data is through Bar & Column Charts. In this type of chart, the visuals contain a rectangular bar. The length of the bar is proportionate to the data values.   To...Read More

MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here we discussed different Business Intelligence tools including SSIS, SSRS, SSAS & many more. Similarly, What is MSBI? and its benefits. Data & Information Data is a technical term. A layman would not understand...Read More

Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware of this feature then go through the below steps. Remove Rows With Errors By Power Query Let’s take an example. As shown in the below picture there is some revenue that has invalid...Read More

As explained in the above example, we have generated a conditional column for the given query. If we want to split this query into two, Power Query will help us in doing so. To get more in-depth knowledge about Power Query, then check our latest Power Query Course that provides high-class videos with life time...Read More

One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s take an example where you have the data set as shown below. Use First Row As Headers By Power Query Here, the headers are not meaningful as it is showing the headers as Column1,...Read More

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a column by the number of characters easily. How to Split Column in Power Query This is helpful when you have columns that you want to split by an equal number of characters, for...Read More

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...Read More

To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has a weapon called DAX. Data Analysis Expressions (DAX) is a library of functions and operators that can be united to create formulas and expressions in Power BI Desktop.     We can deduplicate...Read More

There is one more interesting feature of Power Query where it lets you add an index column that serves as a row counter to your data. Power Query Helps To Create Index Column Let’s go through the steps in detail with an example. Our sample data consists of Months and revenue data as shown in the...Read More

You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have columns that you want to duplicate & make some temporary/permanent alterations to it in the Power Query Editor but not to your source data. In this tutorial, we learn 3 cool steps to...Read More

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

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

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

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

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

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