Forum Discussion
Power Query pivot
- 1 year ago
Hi , sabd80
Please , follow below steps
1) Select Volume , Gross Value , Net Value column with help of ctrl key
then go to "Transform" and select unpivot columns then Unpivot only Selected columnsthen your data will look like this
2) After That select source and attribute column with ctrl key together and go to trasnform and select
merge columns and in separator choose space from the option.
Then your data will look like this3) After that select Newly merged column
and click on Transform data "Pivot" and in value section select Value column
and your data will be in desired stateBest Regards,
Govind Sapkade
Data Analyst | Power BI Enthusiast | Microsoft PL 300 Certified Power BI Data Analyst | MS Fabric Enthusiast
🎥Subscribe to my youtube channel for hands on tutorials : YouTube📊Let’s connect on Linkdin : Linkdin
Hi, sabd80
Thanks for reaching out to the Microsoft Fabric Community forum
I trust the govind_021 response is accurate and will address your issue.
If you have any further questions or updates regarding your issue, feel free to ask, and we will look into that.
If the Super User's answer meets your requirements, please consider marking it as the Accepted solution.
Regards,
Sahasra