cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qwaiti27231 Regular Visitor
Regular Visitor

Need Help -Comission

 

Below table is main establish table . which has comission rates 

est connection separate

 

need to find comission amount for each establishment

 

 

est connection
  
est idorder no
12
23
34
41
56
65
  

 

 

 

 

 

 

 

order noamount
110
215
320
425
530
635

 

 

 

 

Est_abcommissionEst id
a101
b122
c103
d104
E125
f106

 

 

 
2 REPLIES 2
dramus Established Member
Established Member

Re: Need Help -Comission

Try adding this column to the orders table.

 

Commission Amount = [amount] * LOOKUPVALUE(Commissions[commission],Commissions[Est id],RELATED(Establishments[est id]))/100
qwaiti27231 Regular Visitor
Regular Visitor

Re: Need Help -Comission

@dramus It didnt work . they are three tables 1.Connection table 2.Order table 3.Est table Comission of each est name has to be founded with given commission rate 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 55 members 1,240 guests
Please welcome our newest community members: