Need to find date difference between two different tables in power bi

I have created a solution in Excel based Power Query which you can download from https://1drv.ms/x/s!Akd5y6ruJhvhujd-m0li-RwWbFUS?e=hB3NG1 

This is the output query

let
    Source = Table.NestedJoin(Table1, {"EmpID"}, Table2, {"EmpID"}, "Table2", JoinKind.LeftOuter),
    #"Expanded Table2" = Table.ExpandTableColumn(Source, "Table2", {"Action", "Termdate"}, {"Action", "Termdate"}),
    #"Added Custom" = Table.AddColumn(#"Expanded Table2", "DateDiff", each Number.RoundDown(Duration.Days([Termdate]-[Servicedate])/(365/12),0)),
    #"Added Custom1" = Table.AddColumn(#"Added Custom", "DateDiff/12", each [DateDiff]/12)
in
    #"Added Custom1"

MahamoodBi 

Check your solution in DAX:

Output =
ADDCOLUMNS(
    ADDCOLUMNS(
        SUMMARIZE(
        'Table 1',
        'Table 1'[Empid],
        'Table 1'[status],
        'Table 1'[Servicedate]
        ),
        "Action", LOOKUPVALUE('Table 2'[Action],'Table 2'[Empid],'Table 1'[Empid]),
        "Date Diff", DATEDIFF( [Servicedate], LOOKUPVALUE('Table 2'[Termdate],'Table 2'[Empid],'Table 1'[Empid]),MONTH)
    ),
       "DateDiff/12", DIVIDE([Date Diff] , 12,0)
)

Hi MahamoodBi

you can merge these 2 tables into 1 in Power Query (merge tables using empid)

in DAX calculated column

DATEDIFF (DATE1, DATE2, MONTH) /12
Thanks & Regards,

Mohammed Adnan