Forum Discussion
When did/why did MS get so bad?
So, my business has spent thousands on Power BI and is still no better than using Excel. I stupidly thought it would be easy to find solutions to issues, like it was with Excel. Wrong! I've spent...
lbendlin
Super User
Super UserYou may want to use a Duration field type, not a Time field type.
As for the forum logout/loss of entered post - that is indeed a very annoying issue in this forum, however not really related to Power BI.
Unfortunately, that doesn't work either.
In Power Query, if I change type to Duration, when I close & apply, the result in the table is a decimal. In any visualisation, this will sum ok.
In the table, if I change the data type to hh:mm:ss: a) I am no longer able to summarise the results, b) Again, the results do not extend past 24.