lookup Value for multiple column with range

[manoplaeli]

Hi all, need your help.

What I wanted to do is quite simple which is to add description in another table base on the country name and the amount that fit the proper threshold. I have two tables as below and want to add description in the red box.

       

Thank you in advance,

[manoplaeli]

@amitchandak This works perfectly, thanks man.

[amitchandak]

@manoplaeli , a new column in table2

Table2 = maxx(filter(Table1, Table2[Purchase Amount] >= Table1[Threshhold from] && Table2[Purchase Amount] <= Table1[Threshhold to] ) , Table1[Description])

[manoplaeli]

@amitchandak one more question. I just realise that the purchasing amount need to be grouped in one Purchasing Order Number before evaluating the threshold level. 

The coding above is also not filtering the country.

Many thanks,

[V-lianl-msft · Accepted solution]

Try to create a new purchasing amount column:

new_purchasing amount= CALCULATE(SUM('Table'[purchasing amount]),FILTER('Table',EARLIER('Table'[purchasing order number])='Table'[purchasing order number]))

Replace purchasing amount column with the new column in the previous formula.