Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Tips and Tricks
Tutorial Requests
  • TomMartens's avatar
    TomMartens
    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