Forum Discussion

Radhika_Kanaka's avatar
Radhika_Kanaka
Icon for Helper I rankHelper I
4 years ago
Solved

Rounding to nearest minute in DAX

Hi,  I am trying to round the time to the nearest minute. Can someone help me to achieve this in DAX? Below is the sample data.   0:11:59 -> 11 Minutes 59 Seconds (12) 0:19:29 -> 19 Minutes 29 S...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Radhika_Kanaka ,

     

    Please try:

    Column = 
VAR _minutes =
    HOUR ( [Time] ) * 60
        + MINUTE ( [Time] )
VAR _round =
    IF ( SECOND ( [Time] ) < 30, _minutes, _minutes + 1 )
RETURN
    IF (
        [Time] = TIME ( 0, 0, 0 ),
        "Not Included",
        _minutes & " Minutes "
            & SECOND ( [Time] ) & " Seconds (" & _round & ")"
    )

    Output:

    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

You can use this expression to round to the nearest minute. Convert the resulting column to type time.

 

In Query Editor

= Number.Round(Number.From([TimeColumn]) * 1440, 0)/1440

 

With DAX

NearestMinuteDAX = ROUND([Time]*1440,0)/1440
 

Pat