Forum Discussion

weakneee's avatar
weakneee
Frequent Visitor
2 years ago

NEGATIVES HOUR

Guys, good afternoon! I would like to ask for your help with a question I am having. I am working with a table that has hours, and there is a negative hour that is giving me a different value than the one I am looking for. I will leave the images below with the examples and expressions I am using. The name "b", in minutes, has to return "-13", as others are doing, however, it returns "47" which is not consistent. Could anyone help me with this? I appreciate your attention!

 

And I did another test and it only returns the decimal "78", which doesn't make any sense to me, because in the table the decimal of "b" is "22"

 

 

 

 

 

DAX
NEGATIVE HOUR

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    you need to do number math as DAX doesn't know durations.  I would also recommend you follow the standard convention where the integers are days and the fractions are, well, fractions of days.

     

    What are you planning to test with these numbers?  The average?

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi weakneee ,

    Please try the following methods and check if they can solve your problem:

    1.Create the simple table.

    2.Create the new column.

     

    test hour = 'Time'[hour] &":"& FORMAT('Time'[minute], "#00")

     

    3.Create Drag the column into the visual.

    4.The result is shown below.

    Best Regards,

    Wsidomw

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