Dear community
I have an issue I hope you can help with. I am new to using data models.
So, lets say I have a sheet with a table ("master"). The Master has about 150 rows and I keep on adding columns. Let's say rows are tasks, Columns are for different purposes, like timetracking, who is assigned, very much details. The amount of columns in Master is growing very large, so it is hard to navigate. I tried to use grouping of columns, hiding, but what I really would find more useful is to work with the views I can create from the Power Query editor. E.g.only working on the columns related to time management on one sheet ("time management"), only working on the columns related to assignment on another sheet. Ultimately all the changes made on these sheets should be reflected within each other, such as:
- a new task (i.e. a new row in Master) is synced to all sheets
- a change on the "time management" sheet should be reflected in the Master sheet (since it contains all the data).
Basically it is like breaking a very broad table into multiple pieces on multiple sheets.
What I have done so far is use the Power Query editor on Master, remove the columns I dont need, and create the sheet ("query")with the selected. I also like the other options that PQ gives me to select what I want to see. However all the changes made on "query" are gone with each refresh of the connection. I guess this is how a Query works - only in one way.
Is there another way of achieving the purposes I outlined? I might be missing the basics... Still: Thank you in advance.
Bookmarks