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 take…
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…
Learn Power Query Tips and Tricks. Power Query is one of the most powerful features in Power BI and the easiest to…
Power Query also allows you to create a list query from a data table available. The column from the given data table…
Sometimes we need to transform the text from a huge data table which is not directly possible. But, with Power Query, you…
You can easily load the data files like Excel spreadsheets in Power Query. But what if your data source is not an…
There is a cool feature of Power Query which is known as ‘Replace Values’ feature. As the name suggests, it can replace…
How to Add Conditional Column in Power Query Step-by-Step. In Power Query, there is a feature to add a new column called…
As you can import the data from Text/CSV, the same way you can import the data from the text file. The reason…
Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how…
Power Query allows you to extract data from any source, clean and transform the data and then load it to another sheet…
If you have multiple Excel worksheets that are in the same format and their underlying differences are their values and dates (e.g….
Sometimes you need to show the data in a reverse form for some of the other reasons. It’s not easy to reverse…