Adding values of two columns in two tables

Question

How to add values of two columns in two tables in power BI from mysql database? I have 1 common field in both the tables, i want to find the sum from both the tables.

Answer 1

Hi Anshuli,

You can either create a separate field after join from query editor and then use DAX .

Follow below steps for :

1. Once you have connected to the mysql database and selected the tables, click on edit.

2. Join the 2 table by common fields and then make the 2nd field in 1st table.

3. Now apply sum over both the fields with DAX code and create a column.

4. Now the sum of both fields is in new field. sum = [col1] + [col2]

Hope this helps you.