Forum Discussion
New Condition Column - Sum
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.
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] ) )
2 Replies
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
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] ) )
