Duration time over 24 hours

[Anonymous]

Hi,

I have a table with reading times of books per customer id.

Some customers read more then 24 hours before they finish a book.

I have already checked https://community.powerbi.com/t5/Desktop/Data-loading-incorrectly-Issue-with-data-type-of-data/m-p/2... and used 
#"Type changed" = Table.TransformColumnTypes(Tabel1_Table,{{"Luistertijd", type datetime}}),
DateTimeToDuration = Table.TransformColumns(#"Type changed",{{"Luistertijd", each _ - #datetime(1899,12,31,0,0,0), type duration}}),

The result is 1.00:37:55 when the customer has read 24:37:55.

So far, so good. But when I want to use it in a table to show for example the average reading time per book it gets transformed in a data type decimal number. In the modelling tab I don't have duration there as an option.

How can I fix this?

Many thanks for the help!

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey · Accepted solution]

Hi @Anonymous ,

Power BI doesn't support Duration data type for time over 24 hours and also not support showing Duration data type in Report view and Data view.

Please refer to these posts to get some workarounds:

Over 24 hour extraction from YYYY-MM-DD HH:MM:SS

Time Duration and Time Graph Plotting.

Best Regards,

Icey

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

[Anonymous]

In addition: so in the Desktop view it's shown as 0,05 instead of a time duration.