Something like Case expression

dgolovanova , Not very clear. If I want to put another table

New column in table 1, assume above table 2

Maxx(filter(Table2, Table1[Brand] =Table2[Brand]  && Table1[Holding] =Table2[Holding] 

&& Table1[Value] >=Table2[start]  && Table1[Value] <=Table2[end] ), Table2[%] )

Or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

It works!

Thanks a lot. 

Hi dgolovanova ,

Is there anything else you need help with regarding this thread? If not, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards