Fellow Power BI Users-
Quick question that I have yet to figure out in Power BI…
I have 2 fact tables and 2 lookup tables. Each fact table uses both lookup tables in order to properly work. For example, I have a date, number of hours worked per record, and an employee ID which I want to report on. I’m attempting to build productivity metrics and the 2 tables have no relationship available except date and employee.
I’m probably not explaining myself we enough so I’m expecting a few questions before an answer.