I have two tables, each are similar except that they contain different types of measured values, for example one contains pressure data, and the other has temperature data.
I would like create a new table that merges the two tables so that I have the two measurements, pressure and temperature, in the same table for each id and time.
As an example, here are the two source tables I would like to merge. My apologies for the formatting. The forum site isn't loading properly for me.
id time pressure id time temperature
A 2019-12-13 1:00 5000 A 2019-12-13 1:00 12
B 2019-12-13 1:00 5200 B 2019-12-13 1:00 15
The resulting table after the merge would look like this:
id time pressure temperature
A 2019-12-13 1:00 5000 12
B 2019-12-13 1:00 5200 15
if i understand correct it shoud be enough to add calculated column to table pressure or temperature like this:
Temperature = lookupvalue('TEMPERATURE_TABLE'[temperature]; 'TEMPERATURE_TABLE'[id];[id] 'TEMPERATURE_TABLE'[time];[time] )
do not hesitate to give a kudo to useful posts and mark solutions as solution
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!