Forum Discussion
Solved
Lookup to another table?
Hi, I have two tables, Table 1 has the Employee ID and Table 2 has the employee ID, expense type, value and transaction date. Some employees in table 1 may not have had an expense and be listed on ta...
Like this?
Filters should ideally come from the dimension table. Your filter (Expense type) comes from the fact table.
No need for a lookup, let the data model do the work for you
showing and displaying a 0 for any employees who dont have a company car expenseTry not to do that, instead leave the row blank.
Like this?
Filters should ideally come from the dimension table. Your filter (Expense type) comes from the fact table.
No need for a lookup, let the data model do the work for you
showing and displaying a 0 for any employees who dont have a company car expenseTry not to do that, instead leave the row blank.
thank you, I got it, it was the relationship type 🙂 I was just over thinking it when it wasnt working!