New Condition Column - Sum

[Hadill]

Hello Friends 

I need some help here !

let's say I have 'Table1', and 'Tabel2'. the two tables have the same column [A] with the same content.

How can I write the folloing in DAX?

I want to add a new column [B] to 'Table1', which is the sum of 'Table2'[X] when the two columns [A] is equal on both tables?

appreciate your help.

[Tanushree_Kapse]

Hi,

Firstly bring the Column X for Table 2 in your Table 1 by LOOKUPVALUE:

Create a new column in your Table 1:

X= LOOKUPVALUE(Table2[x], Table2[A], Table1[1])

Mark this as a solution if I answered your question.Kudos are always appreciated.

Thanks

[AlexisOlson · Accepted solution]

This assumes there is a unique X value per A value.

You can avoid this summing X instead.

B = CALCULATE ( SUM ( Table2[X] ), Table2[A] = EARLIER ( Table1[A] ) )