Home » POWER BI » Power Query Editor

Power Query Editor

The Power Query Editor in Power BI is used to transform or edit data files before they are actually loaded into the Power BI

Conditional Column in Power BI

A conditional column is a column that is generated based on a condition imposed on an existing column in data model. In general, conditional column… Read More »Conditional Column in Power BI

 1,487 total views,  11 views today

Unpivot Columns in Power BI

Power Query provides a feature that is Unpivot columns which allows you to transform columns into attribute-value pairs, where columns become rows. Columns that you… Read More »Unpivot Columns in Power BI

 1,892 total views,  5 views today

Profile Data in Power BI

The data profiling allows a intuitive ways to clean, transform, and understand data in Power Query Editor, which helps you identifying the nuances of the… Read More »Profile Data in Power BI

 1,946 total views,  3 views today

Pivot Columns in Power BI

Pivot column is a feature available in Power Query which allows you turn rows to columns. Basically, Power Query groups each unique values and performs… Read More »Pivot Columns in Power BI

 3,835 total views,  9 views today

Create Index column using a Power Query

Create Index column using a Power Query in Power Bi

Using a Power Query, you can add index column to your data that serves as a row counter to rows in data table, it is really a best feature of power query.

 4,253 total views,  6 views today