Creating DateTime relationship, epoch time

 I got this working! Firtsly I created date/time from epoch timestamp and then separated them to their own columns "date" and "time" after this I followed this instructions to create dynamic date calendar and after that I followed this instructions to create time "calendar".

All tought I'm now facing a new problem with time calendar. As my data has been collected very acurate with epoch timestamp I'm now having times like

0:00:18

0:01:00

0:01:12
0:01:32

0:02:00

In visualisations it's only showing the data which has comed exactly 0:01:00 and 0:02:00 but not the results between them. What would be the best way to aggregate/summarize/round down the data to minute level? I tried MROUND(Data[Time];00;01) but didn't work ^^

Br.Niko 

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/

https://ginameronek.com/2014/10/01/its-just-a-matter-of-time-power-bi-date-time-dimension-toolkit/#CreateTimeTable

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