Forum Discussion
Simple Relationship Build Issues
Hi All, I think this is probably a very simple problem I am struggling with! I have 3 different spreadsheets containing the same column headers but different information. On my Dashboard I w...
Hi Anonymous
If all your tables are at the same granularity you should be able to use Power Query Merge Query as per below
https://www.youtube.com/watch?time_continue=129&v=dTdFt9AvDHA&feature=emb_logo
Otherwise, you can build Dimensions that will filter all three table, please refer
https://radacad.com/basics-of-modeling-in-power-bi-fact-tables
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.