topic New Condition Column - Sum in DAX Commands and Tips

New Condition Column - Sum

Hadill — Wed, 01 Dec 2021 08:09:47 GMT

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 — Wed, 01 Dec 2021 09:27:48 GMT

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 — Wed, 01 Dec 2021 22:24:27 GMT

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] ) )