Time Table

[niyati_61]

Hello all, 

I'm working with live data, and as seen in the TimeStamp Column here, On 1 Day, every 5 seconds the sensor generates data.
Table Name = SensorData

I have created a normal Date Table (As shown below)

How to I create a Time Table for displaying Time like this? I need a Date+Time Column in this Time Table we will create similar to the SensorData table, so we can connect the two tables) Also, at 5 second intervals?

Also, how will the Date Table and Time Table be connected in the data model with this main Source Data?

Kindly need assistance on the matter. Thank you in advance!

[v-jingzhang · Accepted solution]

Hi @niyati_61 

You can extract date value and time value from TIMESTAMP column into two new columns in SensorData table. Change their data types to Date type and Time type accordingly. 

Date = DATEVALUE('SensorData'[TIMESTAMP])

Time = TIMEVALUE('SensorData'[TIMESTAMP])

Create a time table with below DAX. I only include time values in this table and change its data type to Time type. 

TimeTable = GENERATESERIES(TIMEVALUE("00:00:00"),TIMEVALUE("23:59:59"),5/(60*60*24))

When you create relationships, you can link Date table to SensorData table on Date column and link Time table to SensorData table on Time column. Download the attached pbix for details. Hope this helps. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[PhilipTreacy]

Hi @niyati_61 

Download example PBIX file

You don't need to create anything special in your Date Table, or create a Time Table, just because your timestamps are at 5 second intervals.  Just plot the data and it will plot ok, Power BI will work it out.

You can create a relationship between your Date Table [Date] column and the data table [Timestamp] column like so

Regards

Phil