Need help with Dax to calculated - from two different tables field comparision ?

[ashmitp869]

Hi, 

I've 2 tables with no relationship between them, I would like to create a measure to add one column Qualified in table DSR by checking the Timesheet Date with the Date Start and Date End.

will take the red one not yellow 

Output result will be like below image

The Employee Code , Skill Code (DSR) should match with Employee Code , Qualifications ID in (Qualifications table) 

The logic is 

Qualified =

CASE WHEN Timesheet Date < Date End then "Learner"

         WHEN Timesheet Date >Date Expiry then "Not Qualified"

         WHEN Timesheet Date >=Date End and isnull(Date Expiry) then "Not Qualified"

         WHEN Timesheet Date >= Date End and Timesheet Date <= Date Expiry then "Qualified"

Notes : Multiple rows in DSR_DNQ and mutiple rows in Qualifications Table thus I avoid to do merge DSR with Qualifications as it duplicating.

I've included the pbix :

https://github.com/suvechha/samplepbi/blob/main/samplefile1.pbix

@lbendlin will you able to help me  

Thanks

[lbendlin · Accepted solution]