Calculate time difference minutes or seconds

[Darwell]

 

So I have these two columns that are formatted as date / time.

When I use the datediff formule, it works for day and hour, but when I change to minute or second I get this message.

I am connecting via directquery.

Does anybody know are way i can get this information?

 

 

 

[lbendlin · Accepted solution]

subtract the two values, multiply the result by 1440 or 86400

[v-xuxinyi-msft · Accepted solution]

Hi @Darwell 

Thanks for the reply from @lbendlin .

The error is saying that it is unable to convert a DAX query to a query against a data source. There are several possible reasons for this: 

• Complex data models
• Complex DAX used in measure or calculated columns
• Complex transformations created in the Power Query editor

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

subtract the two values, multiply the result by 1440 or 86400