Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

See blank for values that doesn't match Dim Table

Hello.

I have a model with two tables:
Fact Table of Revenue (a), with 2 columns:
1.DepartmentCode
2.Revenue

 

Dim Department Table (b) with 2 columns:
1.DepartmentCode
2.HeadofDepartment

 

They are relationated by DepartmentCode column, with Fact Table being filtered by Department Table.

 

The question I'm facing is: my FactTable of revenue is updated everyday and can have new departmentcods that aren't in my Department Table yet (this table is updated manually as I realize we have new deparments in the fact table).

Does someone know how could I create a table with all departments code, its revenue and its Head of Department but showing also the departments withou Heads?

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi.
    Both table are in direct query. 

     

    Thank you, Antonio