Hi,
I've watched the YT video in the link below, and I'm struggling to relate this to the scenario of salaries.
Slow Changing Dimensions in Power BI
I have a Person Details table which lists employees by their Person Number and has their Start and End dates for each instance of employment, I also have a Salary History table which lists the employee by Person Number, employment Start and End dates and salary start and end dates. The Salary History table has Salary Bands for each record which I will be using to count how many people are in each band for any given month or time period like rolling 12 months.
The Person Details table is linked to the Dates table via inactive relationships using the Employment Start and employment End date.
The Salary History table is linked to the Dates table via inactive relationships using the salary Start Date and Salary End Date. The Salary End Date for those without an end date is 31/12/4712 and this shows someone's current salary, previous salaries for an employee are end dated otherwise.
Using the example in the video link above is there a way I can get the Headcount, Starter and Leavers by Salary Bands accurately from my model for any given period or month when selected?
All help is appreciated here
