topic Re: NEGATIVES HOUR in DAX Commands and Tips

NEGATIVES HOUR

weakneee — Thu, 29 Feb 2024 21:12:21 GMT

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"

Re: NEGATIVES HOUR

lbendlin — Fri, 01 Mar 2024 02:41:42 GMT

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?

Re: NEGATIVES HOUR

Anonymous — Fri, 01 Mar 2024 03:24:52 GMT

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.