difference of calculated time (decimal time and real time format)

[Nakiko76]

one minute is missing, wrong sumDear all, 

actually i am new to DAX and Pover Pivot/BI!

Im having current problem. In my Pivot shows the total time a sum where i have one minute missing.

What did i do so far? I calculated the sum of a column (decimal time) ( by the way in many different ways already)

Afterwards i formated it into a time text formate.

First step: Gesamt_Induzeit:=sum(DAB_W[Induzeit])  = 3079,4666666667

Second step: All_Std.:=int(sum(DAB_W[Induzeit]))           =3079

Third Step: All_Min.:=int(mod(sum(DAB_W[Induzeit])*60;60)) = 27

Last step: All_Gesamt_Zeit:=format([All_Std.];"00")&":"&format([All_Min.];"00")

It would be great, if any one can help me out. i get mad otherwise 😉

many regards 

[Nakiko76 · Accepted solution]

Dear charlotte,

thx for your help. At the end i did solve it with a round function. I am sorry to have replied this late.

regards Nakiko

[Nakiko76]

Hi Charlotte,

First of all many thx about your answer. Unfortunately it is not about a datediff.

The only problem is that (see first screenshot - with red mark). IF you sum all data then there supposed to be the result 10:36 and not 10:35 - one minute is missing and i dont get why. 

best regards

[Anonymous]

Hi, @Nakiko76 

There is a possibility that there are seconds in the time of the source data, and rounding up after summing gives one minute less.

The time can be changed to be viewed in this format.

Best Regards,

Community Support Team _Charlotte

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

[Anonymous]

Hi, @Nakiko76 

You can try the following methods.

difference = DATEDIFF([Time1],[Time2],SECOND)

Column = TIME(0,0,[difference])

If this fails to solve your problem, please advise what your desired outcome is?

Best Regards,

Community Support Team _Charlotte

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