Forum Discussion
Combine multiple table with raw measures in 1 graph
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 !!!
Super Useremiel , Need some sample data.
You can have the same column names and then you can append in power query
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Hi amitchandak thanks for you guidance, but it doesn't seem to work, I probably am doing something wrong.
I'm getting the result as shown below, both different values are merged, even the one with the same date/timestamp is merged corretly. But the date/timestamps are not added and shown empty.
any ideas?
thx!