Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Measure - Hours and dates

Hi guys,   I have two tables.   First table: Table with this columns about some calls: date and hour [dd:mm:YY hh:mm:ss], travel code, client, call duration [hh:mm:ss] Second table: Table with s...
v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous 

Not fully sure what you want. Can you share you expected result for further investigation?

You can try formulas as below:

 

diff1(seconds) = DATEDIFF(SUM(Table1[Call started]),SUM(Table1[Call ended]),SECOND)
diff2(seconds) = DATEDIFF(SUM(Table2[Start travel]),SUM(Table2[End travel]),SECOND)
Percentage = [diff1(seconds)]/[diff2(seconds)]

If I have misunderstood, please feel free to let me know.

 

Best Regards,
Community Support Team _ Eason