Forum Discussion
Calculated column Table - Dates
no need to modify the DAX, update the relationship between tables.
pls see the attachment below
Hi ryan ,
Thanks again for this, it works! As I had submitted a simplification of my current model, I was wondering if you had any idea of how to incorporate the notion of employee in the model. I have added a table to identify employees (Stakeholder ID) will link with the payroll table and Membership_SID will link with the membership with the employment table.
In fine, I am trying to capture the data by employees.
Thanks in advance!
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.
then pls provide the sample data that you are using for the testing. provide the data of three tables.
you can just paste the table in the reply. then let me know what's the expected output.