Need Help? Chat with us
[email protected] +1 203-349-9909 / +91-8080042523

Category

Power BI

Read How to Remove Rows With Errors Using Power Query

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 below picture there is some revenue that has invalid values....
Read More

Learn How to Split Queries In Power Query

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. How to Split Queries In Power Query The user will be able to mark a set of consequent steps, starting at the...
Read More

Learn How to Create Index Column Using Power Query

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

Read How to Remove Duplicates Using Power Query

Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually. Remove Duplicates by Power Query Suppose you have this set of data. As you can see the marked ones are...
Read More

Acquire Knowledge to Fill Down Values Using Power Query

Power Query helps you to perform a series of steps to transform your data. Among which there is a step that allows you to fill data down easily. This feature is specially used to fill the missing data where predictions are available for the missing data. Power Query Helps To Fill Down Values Let’s suppose...
Read More

Steps to Remove Columns Using Power Query

Another feature of Power Query is Remove Columns. This feature allows you to remove the unwanted columns easily. Learn Steps to Remove Columns By Power Query This is helpful when you have columns that you want to eradicate and do not need in your final report – but do want to keep in your source...
Read More

How to Use First Row As Headers in Power Query

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

How to do Duplicate Columns in Power Query

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. Duplicate Columns Using The Power Query Editor Suppose you...
Read More

Split Column in Power Query

Power Query helps you to perform a series of steps to modify your data. One of the steps is to split 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 eg....
Read More

Keep Duplicate Records in Power Query

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

Connect to Data in Power Query

Power Query is the Microsoft Data Connectivity and Data Preparation technology that allows the users to flawlessly access data stored in hundreds of data sources and reshape it to fit their needs. What is Power Query Editor in Power BI? Power Query can replace, merge, clean and transform all the messy data and display it in...
Read More

Power Bi Dax Deduplication Based On Column

To do 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 any data based on a column...
Read More
1 2 3