Forum Discussion
Denormalized table for project data
Ahh, i see.
I uploaded a .pbix here.
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2Wg
Well, what is the correct department?
Right now it's just matching up the 1.st entry of Division with 1.st entry of department. 2nd entry of division with 2nd entry of department, and so on.
NickolajJessen I have division-department tables in the datawarehouse like mentioned in the question.
| Division_PK | Division |
| 1 | Division IT and digital |
| 2 | Division Management and consultancy |
| 3 | Division bank housing purchase and business development |
And we have table also for department which connects to division.
| Department_PK | Department | Division_FK |
| 1 | Digital customer services | 1 |
| 2 | Real Estate Management | 2 |
| 3 | ABC Bank | 3 |
So is it possible to map the departments I get in the project with the table in DWH and create the list? Then with that I can get the corresponding division via Division_FK in the department table.
PP
Ahh, i see.
I uploaded a .pbix here.
https://drive.google.com/drive/folders/1AjePk7NUXAloXHr42BEa2lDOr5dQr2WgThank you so much! Will this work with my original department table with 590 rows?
Only one way to find out 😉