Sum two columns amount of two different tables by year

[dummip]

Hello all,

I am new in Power BI Desktop.

I have two separate tables which are US Sales and Europe Sales accordingly.

I need to create a Bar Chart (or a Pie Chart) to show the total sales amount of two tables.

I have no idea on how to create the total amount column or table ?

Could you please advise me how to do that ?

Thank you very much !

[dummip]

Unfortunately, two tables with a little bit different columns number and information. I am afraid that they cannot be combined. Does it have any other way ? Thanks in advance. 

[lkalawski]

Hi @dummip ,

In this case you have to connect somehow these two tables (directly or by using calendar table and year as a key) and use the measure which I shared in the previous message.

Please share your data model and then we will help you more.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[dharmendars007]

Hello @dummip , 

Looking at the screenshot I think you have data in excel, if so you can convert those to table and load them to Power Bi Desktop and either use Option Append Queries to Union both table and sum the amount or Join the both the table using merge queries and then sum both Amount colum (US and Europe).

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[lkalawski · Accepted solution]

Hi  @dummip ,

If you have created relations between tables (e.g. using Year) or an additional calendar table, then this measure will calculate the total:

Total Sales = SUM('US Sales'[Amount]) + SUM('Europe Sales'[Amount])

However, if you have the same table structure for US and Europe, it would be best to combine them into one table, add a column (Continent), and then write a measure that calculates the sum on the Amount column. When you want to split per Continent, you just need to use that column as a Legend in the Bar Chart.

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin