Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculate time difference minutes or seconds

 

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's avatar
    lbendlin
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 

     

    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.

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    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.