fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Day

February 27, 2019

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
Need Help? Chat with us