Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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!!
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!!
User | Count |
---|---|
21 | |
20 | |
13 | |
10 | |
8 |
User | Count |
---|---|
30 | |
28 | |
13 | |
12 | |
11 |