Forum Discussion
Data Transformation in PowerBI from JSON format
Hey guys, I am pulling some JSON data and am trying to move a column to a row. Please see the below pictures: After some initial transformations, I have the following table. Here, the test1 co...
Hi Anonymous ,
You may check the pivot and unpivot feature in Query Editor.
https://docs.microsoft.com/en-us/power-query/pivot-columns
https://docs.microsoft.com/en-us/power-query/unpivot-column
Best Regards,
Jay
Hi Anonymous ,
You may check the pivot and unpivot feature in Query Editor.
https://docs.microsoft.com/en-us/power-query/pivot-columns
https://docs.microsoft.com/en-us/power-query/unpivot-column
Best Regards,
Jay
Hi Jay,
Yup I figured something out with the pivot columns on Wednesday.