Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to Solution.