Forum Discussion
Duration time over 24 hours
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/223210#M99223 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!
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.
3 Replies
- Icey
Community Support
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.
- 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