Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

add time

I have to sum the time in a particular format.   for Example :   9:26:22 9:22:14 9:12:27 9:05:25 9:15:24 Sum is 46:21:52 - i have to get in this format.   But, when i am trying to do in po...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may add Table1 in your formula. Attached the sample file.

    New Time =
VAR a =
    SUMX (
        Table1,
        HOUR ( Table1[Time] ) * 3600
            + MINUTE ( Table1[Time] ) * 60
            + SECOND ( Table1[Time] )
    )
VAR hours =
    TRUNC ( a / 3600 )
VAR minutes =
    TRUNC ( MOD ( a, 3600 ) / 60 )
VAR seconds =
    MOD ( a, 60 )
RETURN
    hours & ":"
        & minutes
        & ":"
        & seconds

    Regards,

    Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

 

Example :   In Excel - 4:46:35 we can change that format to 64:46:35(Custom format - [h]:mm:ss;@)

 

But in power BI  how can we change that this time (4:46:35) to 64:46:35.

 

Please reply ASAP. 

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

There's no custom format in power bi.You may create a calculated column to get it.

 

Regards,

Cherie