Forum Discussion
Helper IIRecognise Column as a Time?
Helper IIHi camargos88 ,
That didn't seem to work for me however, I think we're on the right track. One of my friends recommended trying to transform the column and assign time to the columns. Any idea how I can go about doing that?
Community Champion- CalvinL
camargos88 Appreciate the reply. Unfortunately, that didn't work for me. I found another way around it though. I went into my data set and unpivoted the set so that there's a half hour 1, half hour 2 etc. value for each date. Now my problem is changing all the times in the date column to match the half hour 1, 2 etc.
Sample data (what it looks like now):
Date Attribute Value 01/01/2020 00:00:00 Half hour 1 10 01/01/2020 00:00:00 Half hour 2 12 01/01/2020 00:00:00 Half hour 3 15 01/01/2020 00:00:00 Half hour 4 16 - camargos88
CalvinL ,
The m code does it.
Check this file: Download PBIX
Did I answer your question? Mark my post as a solution!
Ricardo- CalvinL
Thank you for the file. So that custom column works, but only goes as far as 04:30:00 for some reason and then just repeats from there. Any ideas as to why it does that?
Also, would there be a solution to just increment the time in the date column rather than creating a new separate column for this?