Forum Discussion
Anonymous
5 years agoNot applicable
Creating visuals and slicers that utilize multiple tables with no relationship
I can't seem to find a way to accomplish this task. I have an excel workbook that contains sensor measurement data. Every week the sensors collect measurments, and we pull those measurements into...
- 5 years ago
Hey Anonymous ,
please provide sample data, meaning a workbook, that contains more than 2 sheets. Upload the the workbook the onedrive or dropbox and share the link.
I recommend to stitch the data from the each sheet on top of each other (append opeartion in Power Query) using the sheetname as an additional column.
Regards,
Tom
TomMartens
Super User
5 years agoHey Anonymous ,
please provide sample data, meaning a workbook, that contains more than 2 sheets. Upload the the workbook the onedrive or dropbox and share the link.
I recommend to stitch the data from the each sheet on top of each other (append opeartion in Power Query) using the sheetname as an additional column.
Regards,
Tom
Anonymous
5 years agoNot applicable
This ended up working for me, sorry for the late response.
Thank you!