CODEWITHSUNDEEP
powerbidax
Oliver
Oliver

Reputation: 619

Power BI How to Sum Matched 2 Columns

I have two tables. First one represents sales values of company by department, product ID and month. Second table contains sales target by department and month. I want to add a column to second table. It should shows sum of values from table 1 with grouping department and month.

For Example: For 310101 in Februray sum of values is 110. So, the first row of table 2 should be 110.

Can you please help me with this DAX function?

enter image description here

Upvotes: 0

Views: 1389

Answers (1)

S.Jo
S.Jo

Reputation: 58

Create a calculated column in both tables which will represent an unique ID (Eg: ID = Table1[Dpt ID] & Table1[Month]) and join the both tables by this ID field to create a relationship between these 2 tables.

enter image description here

Now, select all the columns from Table 2 and also select Value column from Table 1. You should get the sum by department.

enter image description here

Upvotes: 0

Related Questions