Forum Discussion
Calculated column Table - Dates
no need to modify the DAX, update the relationship between tables.
pls see the attachment below
can't see the whole picture, so can't provide the best soluiton. i think the easiest way is to combine the payroll and employment tables.
maybe you can proivde the sample data and the expected output
Thanks Ryan, I've tried to attach the Pbix file in my early post but can't seem to find the option for file attachment? I was trying to avoid merging both Employment and Payroll tables given that tey are very heavy already. The output result would basically be the same than the one you provided except that it is now looking at several members records (different pay rate) and (different payroll dates). Let me attach the file as soon as I find the option (such a silly situation..) but thanks again for your time here, really.