Compliance Check on EmpNo

You can so it using lookupvalue or maxx in this case

New column in Employee1

Onboarding= maxx(filter(onboarding,onboarding[Emp ID] = emp[Emp ID] ),onboarding[onboarding Date])

Other examples

New column in Table 1 = maxx(filter(table2,table1[customer] = table2[customer] && table2[option]="construction",table2[value])

New column in Table 1 = maxx(filter(table2,table1[Attribute] = table2[name] && table1[project] = table2[project]),table2[name])

https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax
new Column =
LOOKUPVALUE('Shops Products'[Lot No.], 'Shops Products'[Entry Type], "Output", 'Shops Products'[Document No.], firstnonbank('Shops Products'[Document No.],true()))

Hi NoelGrieve,

You can also try the below function to Create a Table:

Table = Filter(NATURALINNERJOIN('Employee Table','Onboarding Table'),'Employee Table'[Employee No] = 'Onboarding Table'[Emp ID ])

 

 

Thanks,

Harsh Nathani

 

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!