Forum Discussion
HR Dataset from multiple CSV files
Hi Anonymous ,
Believe that your best option is to make a Dimension table with the ID of the employee to make the relationship between the 3 tables that way and using this table on your visual should give you only one value per count.
If you want to merge all the table into one you need to use the Query Editor with the Table.Combine, check the post below with a full explanation of the join types and how to do it.
https://radacad.com/how-to-change-joining-types-in-power-bi-and-power-query
However be aware that using this type of aproach you will then probably need to have a distinct count instead of a count of your data.
Regards,
MFelix
Thanks for your reply.
I did try to create a Dimensions Table using employee ID with the thinking that this would link both tables and create a relationship allowing me to cross select values between both tables. This did now however help as when I select data from the first table and another from the second table, I got an error message and no visual was displayed. Could I be doing it wrong?
The relationship between the heads table and the Starter and Leaver table is such that the heads table has multiple instances/rows of employees for every month they have been with the business since April 2018 while the latter two have just one instance i.e. when they joined (starter table) or left (leaver table) so ideally, the heads table should contain everyone in the starters and leavers table, the starters should contain everyone in the leavers table and the leavers would only contain instances of the heads or starters if they have left.