Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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.
In addition: so in the Desktop view it's shown as 0,05 instead of a time duration.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |