Relation between 2 tables without matching identifiers (yes, I know...)

[Anonymous]

Hi, I am struggling with finding a relation between two tables that both have a timestamp - but not matching ones.

Table1: temperature sensor data recorded every 5 seconds:

Table 2: information on which product has been manufactured - timestamp relates to when each product was finished

For analytic purposes, I would like to know in table1 which product was manufactured at any given time. As you can see, I can´t related both tables by timestamp. In Excel, I couldn´t use VLookup either but basically for timestamp in table1 I searched for the closest timestamp in table2 (with matrix formula) - takes ages to compute.

Do have you have idea how I could solve this problem in PowerBI?

Thanks

Alexander

[Phil_Seamark · Accepted solution]

Hi @Anonymous

You possibly don't need to relate them at all.  Rather, why not create new columns in both tables, rounded to the nearest minute and then join both tables to a Time table.

This will allow you to create COUNT based measures for each time bucket and still plot on a visual.

[Anonymous]

Thanks. Indeed, why didn´t I think of that. Perfect.

Alexander