Forum Discussion
Solved
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 w...
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] ) )
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] ) )