Forum Discussion
Creating DateTime relationship, epoch time
I've got this now working! Firstly I converted the epoch timestamp to time/date. Then I separated time and date to their own columns. After that I followed up these instructions to create dynamic date and time calendars with power query
http://databear.com/2016/11/08/power-bi-tip-dynamic-calendar-table/
All tought I'm having a bit issue with time calendar. Since I've collected the data very acurate with epoc timestamp . I might have times like
0:00:18
0:01:00
0:02:14
0:03:45
0:04:00
...
Time calendar has been created on minute level and that is the level where I wanna track also my data.
In visualisations mode it's now only showing the timestamps that have exact the same value. In this case it would show only the values behind the time 0:01:00 and 0:04:00. What would be the most convenient way to get rid off seconds and convert time to nearest minute?
Br.Niko
Hi Niko,
You could add a new column with this formula:
Bridge = FORMAT ( [Minute], "hh:mm:00" )
Best Regards!
Dale