Forum Discussion
Need to find date difference between two different tables in power bi
Hi PBI Experts, I have Table 1 and Table2 data in Table1 i have a ''Service date'' Column and Table2 i have Termdate column , i need to findout date difference between (Table1)Servic...
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