Using Pivot Table | Power Query | Power BI | Cleaning
A good example of how to use Pivot transformation using Index.
In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, does an aggregate calculation for each value, and pivots the column into a new table.
PBIX File ... https://github.com/BroRajIntelligence...
Full set of Tutorials for Power BI
---------------------------------------------------
Introduction to Power BI (videos)
https://github.com/BroRajIntelligence...
Power Query (videos)
https://github.com/BroRajIntelligence...
DAX (videos)
https://github.com/BroRajIntelligence...
Visualization (videos)
https://github.com/BroRajIntelligence...
Service (videos)
https://github.com/BroRajIntelligence...
Interview Questions (videos)
https://github.com/BroRajIntelligence...
__________________________________________________________________________________
Kindly like, subscribe and share among Power BI aspirants