duration

2 Topics

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?
Solved
Anonymous
1 year ago Place Report Server
16KViews
0likes
5Comments
new workskpace/app creation preview duration
I'm new to Power BI - we are starting to use the 'Try new' Workspace creation inteface that is currently in Preview mode. How long are these new features typically in Preview mode before they become the default? What I've read about this preview - is it will become the standard and we will need to migrate any Workspaces created in the 'old' way. Is there any way to make the Preview the Default so no new workspaces are created the old way - before this preview becomes the Only way? Thanks
posnyds
7 years ago Place Report Server
658Views
0likes
1Comment