Something like Case expression

[dgolovanova]

Good afternoon.
Help me, please.
There are two tables (filtered for clarity), the connection by Holding and Brand.
Need to calculate the proviso depending on the range in which the value falls.
In my example it should be 21% of the number 10,867,091.6.
Thanks in advance for the tip.

[amitchandak · Accepted solution]

@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.

[dgolovanova · Accepted solution]

It works!

Thanks a lot. 

[amitchandak · Accepted solution]

@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.

[dgolovanova · Accepted solution]

It works!

Thanks a lot. 

[v-yiruan-msft · Accepted solution]

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