Forum Discussion

Frequent Visitor

8 years ago

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...

Anonymous
8 years ago
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
Calculating a monthly employee count from a start and end date range.pbix112 KB

Frequent Visitor

8 years ago

Great help. Thanks!

Anonymous

Not applicable

8 years ago

bwaetford,

If my method solves your issue, please accept my reply as solution to close this thread.

Regards,
Lydia