Coverting 24 hr time in Power BI

[Liz_Green]

Hi everyone

I’m attempting to covert a column of numbers into 24 hours time in Power BI.

Here’s an example of what I’m working with below in my data

Time

716
958
1213
1845
1922

716 is 07:16 AM.

I’m looking to convert this to a better format for Power BI somehow. I don’t really mind where it’s done, either with DAX or query editor at the moment. I’m not sure what would work better.

Thanks for your assistance with this.

[Nick_M]

@Liz_Green
In PowerQuery you can add a custom column with the following code:

 Text.PadStart(
    Text.From([Column1]),4,"0")

and then set the data type of that to time:

Nick

[sam.mckay]

Nice easy one from Nick there.

Here’s an idea around doing this with a calculated column also

Column = CONCATENATE(CONCATENATE(LEFT([Time],LEN([Time])-2),":"),RIGHT([Time],2))

Hopefully this gets you what you require here.

Thanks
Sam