Hey community!
I am getting deeper and deeper into the world of Power Query and Power Pivot. It brings a lot of potential and makes my job a lot easier. Currently I am facing the following problem:I have the following two tables in Power Query, which I want to load in Power Pivot and present them as Pivot Table, etc .:
TblContracts
<tbody>
</tbody>
TblStaff
<tbody>
</tbody>
I now connect both tables using a calendar table and the date. Now I have to somehow connect the Sections, Areas and Departments to get a value from Contracts / Number of Employees at the end.
How is this implemented?
Using Hierarchies?
And, how can I upload a sample table here in Foum? I can not find an entry anywhere.
Do you need more information?
greetins
I am getting deeper and deeper into the world of Power Query and Power Pivot. It brings a lot of potential and makes my job a lot easier. Currently I am facing the following problem:I have the following two tables in Power Query, which I want to load in Power Pivot and present them as Pivot Table, etc .:
TblContracts
Date | Section | Area | Department | Contracts |
01.01.2018 | A | 1 | AA1 | 900 |
01.01.2018 | A | 1 | AA2 | 500 |
01.01.2018 | A | 2 | AA2 | 550 |
02.01.2018 | A | 3 | AA1 | 500 |
02.01.2018 | B | 1 | AB | 5 |
02.01.2018 | A | 3 | A | 5500 |
05.01.2018 | A | 1 | A1 | 550 |
<tbody>
</tbody>
TblStaff
Date | Section | Area | Department | Staff |
01.01.2018 | A | 1 | AA1 | 9 |
01.01.2018 | A | 1 | AA2 | 8 |
01.01.2018 | A | 2 | AA2 | 9 |
02.01.2018 | A | 3 | AA1 | 50 |
02.01.2018 | B | 1 | AB | 1 |
02.01.2018 | A | 3 | A | 55 |
05.01.2018 | A | 1 | A1 | 1 |
<tbody>
</tbody>
I now connect both tables using a calendar table and the date. Now I have to somehow connect the Sections, Areas and Departments to get a value from Contracts / Number of Employees at the end.
How is this implemented?
Using Hierarchies?
And, how can I upload a sample table here in Foum? I can not find an entry anywhere.
Do you need more information?
greetins