Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to build a Power BI model based on HR data. I have a main EmployeeDetails table, which contains a Personnel Number and basic employee details. I also have many related dimension tables which contain date delimited information about each employee. These are all 1-to-many tables, as this information can change over time for each employee. It includes details such as the Org Unit they belong to, Pay details and Address information. As this info changes over time, these tables have a start and end date.
As you can see, I also have a date dimension, but I do not know how to relate this to my tables, as there is both a start and end date.
I need to be able to set the date filter to a specific day and be able to dispaly the Org Unit, Pay Details or Address information that are relevant for that date.
At the moment I just have a single measure, which is a simple count of employees.
Any help is appreciated.
Hi @cmncp,
In my opinion, I think you can try two calendar tables. One for the Start Date and one for the End Date.
And for more specific requirement, please share us some sample data and its expected result.
Thanks,
Xi Jin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |