Forum Discussion
Duration in matrix - difference between two time record
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 ?
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 👍
2 Replies
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 👍
Hi Idris,
I tried typing down DATEDIFF in the custom coloumn, it didnt take the value.
and this was the output
