Pivot & Unpivot Transformation of Columns in Power Query Editor
Yes! Yes! Yes! You can make a Pivot table in Power query too. In this webinar, we will discuss Table transformation of Pivot to the Unpivot table. Yes, we have to convert the cross tab table to an Unpivot table to make reports. Let's Discuss Why we need to change with a couple of examples.
No summarise report, not a chart can be made with the Pivot table / Crosstab table. If you have a 90-degree table as a source you must convert it to unpivot first like shown in the image.
I hope you find the difference. See the webinar.
Meeting link will be sent to your registered mailing address. If you have not registered yet so CLICK HERE to Register.
No comments:
Post a Comment