Forum Discussion
Creating DateTime relationship, epoch time
Hi Niko
As your picture showed, it seems you added the [puredate] to a wrong table. You should add it to table [data]. Please have a try.
Best Regards!
Dale
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
Hi Niko,
Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.
Best Regards!
DaleHi v-jiascu-msft
I've been busy with some other project but tried this trick today and it didn't work. I think this might work if I would do it in query mode (with M) not with DAX. Like I did the date and time table and then they started working. Is there someone reading this post who would know how to do this (TimeNoSec = FORMAT ( [Time]; "hh:mm:00" ) in M?
-Niko