Transposing a data set is ultimately rotating data from rows to columns, or from columns to rows. To understand this concept, an…
In this article let us understand the Bar & Column Charts in Power BI visualization. One of the most common ways of…
MSBI is an abbreviated form of Microsoft Business Intelligence. To understand MSBI, it is important to understand BI (Business Intelligence) first. Here…
Do you know that Power Query can clean your data and remove rows that have inaccurate data? If you are not aware…
As explained in the above example, we have generated a conditional column for the given query. If we want to split this…
One of the features of the Power Query is that it allows you to promote the first row as column headers. Let’s…
Power Query helps you to perform a series of steps to modify your data. One of the steps is to split a…
Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst…
To do Power BI DAX deduplication based on column or to eliminate the duplicate data from a data set, Power BI has…
There is one more interesting feature of Power Query where it lets you add an index column that serves as a row…
You can also duplicate the columns easily using the Power Query Editor in Power BI. This can be helpful when you have…
You can add comments to your code either with single-line comments that start with ‘//’ or multi-line comments that start with ‘/*’…
Power Query also allows you to create a list query from a data table available. The column from the given data table…
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…