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?