Forum Discussion
Solved
Combine multiple table with raw measures in 1 graph
Hi All, I'm measuring energy consumption and write the results in an SQL database. The measures have 2 columns: a date/time stamp and the value. I'd like to combine the various tables into 1 grap...
1. Load two tables in Power Query (Table 1 & Table 2 for example)
2. Make sure that Value columns have different names, just rename it like Value 1, Value 2
3. Select second table, Transform tab go to Append as new
4. Close & Apply and use the new table in Table/Matrix visual as select time, Value 1, Value 2 columns
Appreciate your Kudos !!!
Some samples, first the two different SQL tables:
I'd like to add them into 1 new table like this: