QUOTIENT rerurns 0 when it should not

LoonaMoon — Tue, 19 Oct 2021 03:48:56 GMT

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

Re: QUOTIENT rerurns 0 when it should not

VahidDM — Tue, 19 Oct 2021 05:17:16 GMT

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!!