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 ...
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.
bcdobbs
Community Champion
Community ChampionI 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.
Hello! Sorry i dont know how to delete a thread. Actually i figured it all out, I did a Append Query on Power M and all 6 tables combine into 1 like magic! Anyway thanks for replying appreciate it!