Time comparisions in DAX

[AnilKumar]

PLEASE PROVIDE SOLUTION FOR ,HOW TO COMPARE TIME COLUMN IN ONE DATASET WITH TIME COLUMN IN

OHTER  DATASET(WHAT FUNCTIONS WE CAN USE)?

below in time_all table ,i am trying to create a column which is the comparision results of time_all(headings for column) and init

[v-qiuyu-msft · Accepted solution]

Hi @AnilKumar,

Assume those two tables has a relationship with 1:1, you can create a calculated column below: 

TimeDiff = DATEDIFF('Table1'[time_all],RELATED(Table2[init]),MINUTE)

Best Regards,
Qiuyun Yu