Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Below table is main establish table . which has comission rates
est connection separate
need to find comission amount for each establishment
est connection | |
est id | order no |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 1 |
5 | 6 |
6 | 5 |
order no | amount |
1 | 10 |
2 | 15 |
3 | 20 |
4 | 25 |
5 | 30 |
6 | 35 |
Est_ab | commission | Est id |
a | 10 | 1 |
b | 12 | 2 |
c | 10 | 3 |
d | 10 | 4 |
E | 12 | 5 |
f | 10 | 6 |
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |