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/

ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
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)