Forum Discussion
Creating a new table from two existing ones
Hi,
Can you explain why exactly you want to put them in one table? I'll suggest to create a reliationship between both table and then you'll be able to use both data in any dashboards.
You can also create the relationship and then add the column from one of the two table depending on which direction you've created the relationship with the fonction RELATED.
If you want to absolutely create a new table, I'll suggest to create a new connexion on the table containing all the meterid value and only importing the meter id in order to create the relationship between the tables. THen use the RELATED function to get the column needed. Please keep in mind that it need to be 1 to 1 relationship in order to do this. In a case of an 1 to N relationship it's always the N side that'll have the RELATED function available.
Regards
Samuel Boulanger
The most honest answer of why I want to do this would probably be, because I want to improve my Power BI skills. The reason I started going down this path is because I need to use a line chart to display the billing breakout of all the single components that go into a residential water bill. The components of each bill depend on state and local regulations and differs depending on the region. In a power BI line chart I can only add one data source (from what I have seen), but if I have a single column called [amount] and the sum of amount is composed of multiple sources (service fee, surcharge, metered water,...) then Power BI will plot them on different lines. (see example image).