Forum Discussion

Awollet33's avatar
Awollet33
Helper I
5 years ago

Average X - Calculating Roll up wrong

My subinformation is correct but when it rolls up it is wrong. I am using the AverageX function. Anyone ever have this problem?

 

 

Need Help

2 Replies

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi Awollet33 ,

    Power BI Desktop isn't able to calculate in time format beyond 23:59:59. Calculate your times in industrial format:

     

    Time format Fraction of a day Fraction of a day * 24 =
    Industrial time
    12:00:00 0,5 12
    06:00:00 0,25 6
    14:30:00 0,604166667 14,5
    17:23:45 0,724826389 17,39583333

     

    The final result must be translated manualy with formulas to get the time format hh:mm:ss.

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Awollet33 ,

     

    What's the expected result? And can you share your formula so that we could the what's going on?

     

    Best Regards,

    Jay