Combine two power query tables into a single dashboard table by timestamp and related data

[miguelsus2000]

Hi,

I have two tables which contain device data payloads (Hex).  They all come from a single Azure source, but had to split the tables as the devices are different and the payload information contains the data in different bytes.

First question:  Is there a better implementation to abstract the extraction of the data (e.g. temperature).  Temperature in one device uses one byte, but in toher uses a different byte in table.  

If i keep using the same implementation I have, then i want to dispaly both devices with a single timestamp and show the temperature for each in a joined table.

Table 1 in Power Query

Device  Timestamp  Temp

A           18:00:00      20

B            18:01:01      23

A            18:05:10      20....

Table 2 in Power Query

Device Timestamp Temp

C           18:02:00      31

D            18:03:01      29

D            18:03:10      29...

Expected Table in the report using table or matrix format which i can sort.  But notice that temp adn timestamp come from two different tables.

Device  Timestamp  Temp

A           18:00:00      20

B            18:01:01      23

A            18:05:10      20....

C           18:02:00      31

D            18:03:01      29

D            18:03:10      29...

Any recommendations?

[v-yangliu-msft · Accepted solution]

Hi  @miguelsus2000  ,

Here are the steps you can follow：

1. Enter power query's home – append queries -- append queries as new

2. For the newly built append table, select transform – pivot column

3. Result.

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@miguelsus2000 , On wat is that you Append them in power Query

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

Or in DAX

New Table = Union (Table1, Table2)