Transform Table or Column
Table Transformation:
It is a very easy and important option given to make the table more interactive. there are some tools like Transpose and Group by is playing a major role in the table.
Transposing a Table is the same as Microsoft Excel in Power Query but slightly different. In Excel, the source table transpose but in Power Query transposing will be done in the data model only not with the source. See the image below for what is the mean of transpose the table.
Group by feature is just like a Pivot table. it formulates group by aggregate ( like sum or count ) based on other columns.
Columns Transformation
Pivot & Unpivot Columns: There are only two ways to keep data in the table. It is a pivot table or Unpivot table.
No comments:
Post a Comment