Method of combining time-displacement data taken by multiple sensors

[Anonymous]

Hello all.

I am currently using PowerBI to visualize data from multiple sensors.
Each sensor has a different measurement start time and logging interval, so right now I'm compiling each data into a separate report.

Example:Sensor1 Data

Time	Tempture[℃]	Flow[m3/h]
18:35:02	26.9	100
18:35:04	26.8	110
18:35:06	27.0	95

Example:Sensor2 Data

Time	Pressure [Pa]	Current[mA]
18:35:01	100	100
18:35:11	90	110
18:35:21	95	95
18:35:31	105	115

I want to use PowerBI to connect each data in relation and display them in a single report.
Can anyone think of a smart solution?

I feel like I can do it if I make good use of fill.🤔

[amitchandak · Accepted solution]

@Anonymous , Add both of them to power bi.

Add column Sensor name in both tables

then append both in power query and use for analysis 

Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Anonymous]

Thank you! I could get result I want😀