Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
WmUit
Frequent Visitor

How to get Data type text, to Data type time to calculate total duration per event

Hello Community,

I am making calculations about the duration of multiple events, that's has been calculated with help from an earlier discussion, but the given data is in data type ''text'',  which makes it impossible to calculate the total duration per event (I think it needs to be data type ''time'' to make any calculations). The table is shown below.

 

I made calculations to get the duration when an events starts (gekomen) and when an events ends (gegaan), that duration is per event_ID. I want to know what the total duration per event_ID is. (the ''Calculated Column Duration'' in data type: Text, which makes it hard to make any calculations)

 

My question is, is there an methode to transform this ''Text'' data to''Time'' data (calculated column duration-->Duration in Time column(Data type: Time in minutes)

WmUit_0-1616072845968.png

Greetings,

Wmuit

 

3 REPLIES 3
Anonymous
Not applicable

@WmUit 

 

Use Power Query to do this. I think there is a datatype in M that is called duration and such things like 60:12 can be easily converted to duration. You can add and subtract durations and they will behave as you'd like them to.

amitchandak
Super User
Super User

Hello @amitchandak, I can't convert values above 24:00, (the error is: cannot convert value 52:32:00 of type text to type Date.) Is it possible to filter everything above 24:00h, because there are 7 values above 24h and those values are to high to take in my calculations, so its fine if these values are filtered out and then the data type can be change to time.

 

Many thanks for you effort!

 

Greetings Wmuit

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.