Employees list

[melanid]

Hello everyone, 

I have two different Excel files, one with the employees in 2020, one with the employees in 2021. I need to create a report in which I can filter on the date (on the year more specifically) and get the total number of employees for the filtered year. 

I am a beginner in PowerBI and I don't know how to face this, should I create two fact tables and one dim table.. or should I create two columns, one for the Start Date, one for the End Date, and compare the two tables with a kind of Vlookup? 

If you have any suggestions to help me.. Thanks in advance. 

Best regards,

[Greg_Deckler]

@melanid Add an Append step in Power Query editor to one of your queries where you append the other query. For the query that you appended, right-click the query and disable loading. Alternatively, you could use UNION in a DAX table formula to combine the two tables.

[melanid]

Hi @Greg_Deckler , 

This table is linked to another table (table "Interviewed employees"), so if I append queries, I will have duplicates and the relationship will not be one-to-one (with employee ID) but many-to-many. Do you confirm that this is the good approach? 

Thanks! 

Best regards,

[Greg_Deckler]

@melanid Many-to-Many is not the end of the world. If you are really worried about it, you can create a bridge table of DISTINCT employee ID's for example and use that as a table between your employee fact table and your interviewed employees table. Would need to know more information about your actual data to be sure of the approach. What kind of information is in your Interviewed employees table?