Forum Discussion
Dynamically Connecting Data from one sheet to another
Hello, I am looking to have data taken from one workbook to another. Each column having different option have dynamic totals in another sheet. I am having a hard time connecting the data and just...
Thank you for that! How would I upivot them? I see the refresh option to allow update stats but not unpivot.
Hi DavidM21,
Here is an article describing the process:
https://www.linkedin.com/pulse/leveraging-power-query-data-model-create-dynamically-pivot-torralba/?trackingId=cDnh9lz5av8674ji06mWrA%3D%3D
Please don't hesitate to reach out if you have any questions.
cheers
Here is an article describing the process:
https://www.linkedin.com/pulse/leveraging-power-query-data-model-create-dynamically-pivot-torralba/?trackingId=cDnh9lz5av8674ji06mWrA%3D%3D
Please don't hesitate to reach out if you have any questions.
cheers