Forum Discussion

emiel's avatar
emiel
Regular Visitor
4 years ago
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...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    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 !!!

    https://allure-analytics.com/

emiel's avatar
emiel
Regular Visitor
4 years ago

this works better, it doesn't combine measure on the same date/timestamps, however. But lets see if that works either way.

thanks!

ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

Both tables should have same column name for time if this is the case

Table 1 (Time - Value 1) & Table 2 (Time - Value 2)