Forum Discussion
ekroll
4 years agoFrequent Visitor
Backlog by Location
Hi, I'm still pretty new to Power BI, DAX and such and am trying to figure out how to create a backlog by location. I have 2 fact tables and a calendar table. I've linked both fact tables up to t...
SpartaBI
4 years agoCommunity Champion
ekroll you need to delete the relationship between the fact tables (big no no) and create all the needed dimensions that can connect to both fact tables (just like the date). So DimStores and maybe more. I suggest go watch in SQLBI.COM the free introducion course for data modeling.