Forum Discussion
Awollet33
Helper I
Helper IAverage 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?
FrankAT
Community Champion
Community ChampionHi 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)