Forum Discussion

CalvinL's avatar
CalvinL
Icon for Helper II rankHelper II
6 years ago

Recognise Column as a Time?

Hi all,   First time using Power BI, so apologies if it sounds confusing/doesn't make sense or isn't possible.   Basically, I've got a dataset that records values every 30 mins and stores them un...
Need Help
camargos88's avatar
camargos88
Icon for Community Champion rankCommunity Champion
6 years ago

Hi CalvinL ,

 

I didn't try it after Hour 9, so the code would be like:

 

Duration.ToText(#duration(0, 0, 30, 0) * Number.FromText(Text.Split([Attribute], " "){2}))

 

Also, Hour 48 will be next day ?

 

I've updated the file.

CalvinL's avatar
CalvinL
Icon for Helper II rankHelper II
6 years ago

camargos88 Values are being recorded every half hour (30 mins) hence the 00:30. Sorry for any confusion.

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    CalvinL ,

     

    Could you check the file ?

  • CalvinL's avatar
    CalvinL
    Icon for Helper II rankHelper II
    6 years ago

    Hi camargos88 

     

    Thanks for that. That file seemed to work for me too.. appreciate you answering all of my questions! I've marked your original file post as the solution.