Conversion

[Anonymous]

Hi,

1. Import data from the excel (attached), the datatype in power BI imported in Text Format.

2. Duplicated the column and changed the Data Type to Time and changed the format as below.

3. Identified that the Datapoints above 24 Hrs turned to blank. 

Need the Duration in same format Pls help.

[Icey]

Hi @Anonymous ,

Duration data over 24 hours is not supported in Power BI currently. You can vote similar ideas here to improve Power BI.

If you need to use it for calculations, I suggest you to convert it to "Second". For specific steps, you can refer to another post of yours.

If you want to show it in cards, I suggest you to refer to this blog: 

Calculate Duration in Days Hours Minutes and Seconds Dynamically in Power BI using DAX.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajulshah]

Hello @Anonymous,

I saw the data in the file uploaded by you.

The data in the column is invalid for the Time datatype.

Can you explain further about the column?

[Anonymous]

Hi RajulShah,

In the attachment, i need the data in HH:MM:SS format in the Second Column.

Looking for a dax which can help me to convert Text to HH:MM:SS format.

Regards,

[rajulshah]

But what does the value '506:17:23' mean?

[Anonymous]

Like 506 Hrs spentto resolve this any issue.

[rajulshah]

@Anonymous,

But what should be the value in your calculated column for '506:17:23'?

[Anonymous]

Shard the Link

https://drive.google.com/file/d/1srNmdkQ19t1DaJIhoRsWS19frJ7T9r6n/view?usp=sharing