Forum Discussion
Exporting custom formats with current layout
Hi all,
I should have mentioned that I'm using a measure for calulating total time, I've had to convert time to seconds then a calcuation to sum each hour, minute, second total, so I don't have the option to change the data type to time as the value presented looks like a time value, example return output could be 2160800 which I've then used the custom format option in power bi to ":" to separate the value into hours, mins, seconds so that it looks like 216:08:00. I've tried using TimeFormatted = FORMAT('Table'[TimeColumn], "HH:MM:SS") as you mentioned in your post but I get an error message.
Hi micpete
I did the same thing as you, but it works well too.
If possible, could you please share some raw data(exclude sensitive data) or create some sample data. It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.