time-date
1 Topic
How to convert DATE/TIME Column to duration?
Hello Everyone, I linked an external database to access and then linked from access to PowerBI. I am trying to create a dashboard to extract worked hours, but when doing the link described above, the worked hours came as DATE/TIME, not duration, so PowerBI does not sum the hours correctly, I need to convert DATE/TIME to duration but didn't find any solution to make this. I already tried to do as bellow EDIT QUERY / Transform Collum / Transform Time only = The time came i.e. 5:00:00. Also tried to convert as Duration, but PowerBI just give me a message of error, not allowing to convert it. Can someone help me?Solved16KViews0likes5Comments