Forum Discussion
Filtering multiple Fields over multiple Tables
Hello community! I have a problem, which is so specific that I didn't even know what to search for. I have two tables which I am using in one page of my report, both tables have a column "Project" ...
Got this solution from another forum:
Just set the relationships one way from DIM table to FACT table and there is no ambiguity.
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
For project you can create a table like
project = distinct(union(distinct(Table1[project]),distinct(Table2[project])))
Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Join with both tables. You can do the same in power query too.
You can create date from month, qtr, or year and join with the date table https://www.youtube.com/watch?v=yPQ9UV37LOU