Import Duration Column from csv into Power BI

Hi,

I am importing csv files into Power BI. There are two duration columns; Wait Time and Duration. Power BI interprets them as Time. When I try to change the type to Duration, it gives an error. I need these columns to behave as duration. I have to find the maximum, minimum and average durations too.

I can’t change the csv files as I get a lot of them on a daily basis.

Can someone please help?

Thanks,

Rob

Duration
ChangeTypeError

Can you try this:

image

then for example:

.
I hope this is helpful

Hi Melissa,

Thanks for that. When I tried that I got an error message saying the column was not found on the table.

image

Then I went thru the ‘Applied Steps’ and found where it was setting the column to ‘time’. I changed it to ‘duration’ there and it worked :slight_smile:

Thanks again for your help. Much appreciated.

Hi @Robin, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Also, we’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!