If and And statement from 2 tables with different conditions

[LogiFons]

Hello all,

I am pretty new and can not find my solution in the other posts.

Can you please help me?

I will try to explain (probably harder then the solution 🙂 )

I have 2 tables:

Table A
Number	Description	Season 1
1	Jacket	summer
2	Jacket	spring
3	Trouser	spring
4	Hat	summer

Table B
Order	Description	Season
1	Jacket
2	Jacket
3	Trouser
4	Hat

When:

[Number] from Table A = [Order] from table B

AND

[Description] from Table A = [Description] from table B

Then column "Season" from table B must be filled in by column "Season 1", table A.

The "Numbers" and  "Orders" are unique and have the relation many-to-one.

Has anyone an idea?

Thank you!

[v-xinruzhu-msft · Accepted solution]

Hi @LogiFons 

You can refer to the following calculated column

Season = MAXX(FILTER('Table A',[Number]=EARLIER('Table B'[Order])&&[Description]=EARLIER('Table B'[Description])),[Season 1])

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LogiFons]

Hello,

Sorry, i am mistaking.

In Table A, the column Number is not always unique.

In Table B, the column Order is unique.

Table A
Number	Description	Season 1
1	Jacket	summer
2	Jacket	spring
3	Trouser	spring
4	Hat	summer

Table B
Order	Description	Season
1	Jacket
2	Jacket
3	Trouser
4	Hat

Gr,