Forum Discussion
Something like Case expression
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.
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
3 Replies
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