QUOTIENT rerurns 0 when it should not

[LoonaMoon]

Hi all,

I have a problem with DAX functions QUOTIENT.

I have "minutes spent fact" column and I want to convert it to "X day, Y hours, Z mins" format.

My first step is to divide "minutes spent fact" by 60 to convert minutes to hours

I'm using QUOTIENT function. Here what it returns

QUOTIENT (1320, 60) should return 22. Am I right?  or I get the wrong idea of this function...

Here are other screen with some wrong zero results

[VahidDM · Accepted solution]

Hi @LoonaMoon 

Try TRUNC([minutes spent fact]/60).

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

Appreciate your Kudos!!