Forum Discussion
Duration format
I must make a player time curve, if I use the format HH:MM:00 does not allow graphing.
1. What excel format should I use to gesionar in PowerBi?
2. How could you use the Power Bi Duration format?
2 Replies
You can probably use one of the duration functions in the query editor, or extract the hours/min/sec from the time with those DAX functions. Please provide a mock data table and desired output, and a specific expression can be suggested.
Regards,
Pat
Power Query will generate a duration, but DAX will convert that to fractions of a day. so .5 would be 12hrs. You'd have to reconstruct it as text in DAX to visually show that using the FORMAT() function with a time format.
If you can provide data, we can help.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum
