Suppose there is a huge fact table with lot of orders…now there is another table that calculates commissions… but it has something like this…
the fact table has customer, orderdate, product, quantity, etc…
commissionProfile commission expression
P1 0.5 orderdate > ‘1-1-2019’
P1 1 orderdatedate <= ‘1-1-2020’ and product = ‘Mangoes’
P2 5 quantity > 100
Each customer is associated with a particular profile and we want to calculate commissions for each customer.
I have greatly simplified the structure of the table but this setup lets us have a lot of flexibility in commission schedule.
Is there a way to do it in powerbi?