Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
qwaiti27231
Helper III
Helper III

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
Continued Contributor
Continued Contributor

Try adding this column to the orders table.

 

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

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.