I need a help on a simple query

[Anonymous]

Hi EveryBody,

I have 2 tables

'Promotion' Table

Id      IdTransaction   CodePromo          

 1           1011           A

 2           1012           A

 3           1013           B

 4           1014           C

 5           1015           A

 6           1016           B

 7           1017           C

And 'Group' Table

IdPerson     IdTransaction

13111         1011

13111         1012

13112         1013

13112         1014

13113         1015

13113         1016

13113         1017

I want a formula that add a new column [Idperson] in Promotion table

 Thank's a lot

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may add a calculated column as below:

Column =
LOOKUPVALUE (
    'Group'[IdPerson],
    'Group'[IdTransaction], Promotion[IdTransaction]
)

Regards,

Cherie

[Ashish_Mathur · Accepted solution]

Hi,

If there will never be repetitions in the idTransactions column of the Group Table, then you can create a relationship from the idTransactions column of the Promotion Table to the idTransactions column of the Group Table.  Then write this calculated column formula in the Promotion Table

=RELATED([Group[idPerson])

Hope this helps.

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may add a calculated column as below:

Column =
LOOKUPVALUE (
    'Group'[IdPerson],
    'Group'[IdTransaction], Promotion[IdTransaction]
)

Regards,

Cherie

[SivaMani]

@Anonymous,

Why don't you create a Relationship based on IdTransaction?

It will give the same output that what are looking for now.