Forum Discussion
Table Relationships
Hello,
Currently building a Scorecard dashboard for different towers. My dataset is saved on Sharepoint list (already connected), now i have total of 9 tables (1 table for mapping, 1 table for date and 1 table to be my main table) so technically I have 6 tables (its 6 because it depends on their career lvl, lvl12-13, lvl11 so on) that was connected to Sharepoint list. I connect the mapping table to all 6 tables that was on the sharepoint list so i can use the mapping table for slicers like Employee name, their tower, their manager and their Business Head (Many(mapping) to Many(tables in sharepoint) cardinality). Since i want to put all 6 different tables on 1 table in visualizations, I created 1 table (blank but have all the columns) which im gonna use as main table so that i dont need to create 6 visualization tables for different career levels but i ran into an error if i tried to connect all 6 tables to this 1 table i created which is Main Table that says "that would introduce ambiguity between tables CL12-13". Is it possible to connect all 6 tables (that was on sharepoint) and put it all in 1 table which is gonna my main table? Thanks in advance!
*Sheet1 is gonna be the Main Table
I think you'd be best using power query to append all the tables for each career level together. Create a new column on each called Career Level and assign a static value to each then use the append table function so they're all in one.
2 Replies
I think you'd be best using power query to append all the tables for each career level together. Create a new column on each called Career Level and assign a static value to each then use the append table function so they're all in one.