Forum Discussion
Adding a Common column from two tables into a created table that is shared between the two table
TBensen I think you want to see the data by location (both people and incidents), for which you can create a location table and set it up like the seniority years table (connected to both tables). You can do this with SUMMARIZE to combine and de-dup the locations from both tables.
Locations = DISTINCT(UNION(SUMMARIZE(Employee,Employee[Location]),SUMMARIZE(Incident,Incident[Location])))Then join like you did seniority years.Does that answer your question?
TBensen I think you want to see the data by location (both people and incidents), for which you can create a location table and set it up like the seniority years table (connected to both tables). You can do this with SUMMARIZE to combine and de-dup the locations from both tables.
Hello DataZoe,
This is exactley what I needed! Thank you very much!
Another quick question where would be the best place to learn more about Power BI? Is there a YouTube channel that does a good job going through the different DAX formulas or a book I should read? Just wondering, because I want to learn more about it.
Thanks again,
Trevor Bensen
TBensen Awesome, I'm glad that worked 🙂
There are a lot of fantastic resources out there, which is sometimes a little overwhelming! I personally found the SQLBI.com guys to great for me when I was getting started (I did one of their trainings too) and I'm still learning stuff from them! Tahreem24 also has a great post on her linkedin with great resources organized by category https://www.linkedin.com/posts/tahreem-ansari-44561a16b_powerbi-athomewithpowerbi-taik-activity-6700455131441319936-W1XM
Awesome, thank you again for your help! I will check out these resources.
Thanks,
Trevor Bensen