Forum Discussion
Solved
HR Data - Slowly Changing Dimensions
I am working on an HR report and have a type 2/slowly changing table called employee_data (the table has a "from date" and "to date"). data changes per employee infrequently, but when data changes t...
bwaetford,
Please check if the DAX in attached PBIX file returns your expected result. If not, please share sample data of your table and post expected result here.
Regards,
Lydia
bwaetford,
Please check if the DAX in attached PBIX file returns your expected result. If not, please share sample data of your table and post expected result here.
Regards,
Lydia
Great help. Thanks!
bwaetford,
If my method solves your issue, please accept my reply as solution to close this thread.
Regards,
Lydia
Hi Anonymous thank you for this post.
I tried out this solution and found it works well.
How would you include time in this? as either time by its self or with date...
