Forum Discussion

Belle2015's avatar
Belle2015
Icon for Helper II rankHelper II
1 year ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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 expense

    Try not to do that, instead leave the row blank.

     

     

v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Belle2015,

May i know has your issue been resolved? If the response provided by the super users lbendlin, danextian, Irwan, addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!