Duration in matrix - difference between two time record

[Dhanil]

Hi Everyone,

I'm looking for ideas to calculate the diference between the time values, at first in power query I calculated using the following by adding a cusotm coloumn.

The coloumn added in time format showed error, hence it was converted to whole numbers 

Further the difference showing up in the matrix is not matching up to the actual difference 

The time difference is not adding up, is there a measure or any menthod that can help me solve the issue ?

[Idrissshatila · Accepted solution]

Hello @Dhanil ,

Try datediff dax function by minutes, check this article for instructions https://learn.microsoft.com/en-us/dax/datediff-function-dax

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Dhanil]

Hi Idris,

I tried typing down DATEDIFF in the custom coloumn, it didnt take the value. 

and this was the output