How do i merge/get value with 2 condtions if value= value and yearA=>yearB and yearA =< yearC

[Anonymous]

Hi powerbi experts 

How do i merge/get value with condtions:
Get value from table2.columnX

When table1.columnA =table2.columnB

and

table1.ColumnYear => table2.columnyear1

and 

table1.ColumnYear =< table2.columnyear2

explanation: column a and b are equal each other, yet table B has this key in several rows

to get the right row of value in table2columnX if have to use my conditions above. 

any ideas?

[amitchandak]

@Anonymous , You can create a new column Table1

//You can sumx inplace of maxx

New column = maxx(filter(Table2, Table1[columnA ] = Table2[columnB] && Table1[ColumnYear ] >= Table2[ColumnYear 1] && Table1[ColumnYear] <= table2[ColumnYear 2]) , Table2[ColumnX])

[Anonymous]

Seems like it's the solution, will test properly if i get the right values from table 2 today. Thanks @amitchandak you'are legend!