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
CalvinL's avatar
CalvinL
Icon for Helper II rankHelper II
6 years ago

Thank you camargos88 

 

So I've got 48 values for half hour.. how would my code look like for that? Half hour 1 would be 00:30, half hour 2 would be 01:00 up to half hour 48 which would be 00:00

 

Re: "Also, would there be a solution to just increment the time in the date column rather than creating a new separate column for this?"

 

What i meant by that is - can we use a function like the DateAdd function to just increment the current date column by +00:30?

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.

  • 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.

  • 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.