Forum Discussion
Range Lookup
Hi Experts, I have a data in 2 sheets one is fact table and one i am creating for targets for calculating commissions. Below is the example of dataset, would really appreciate if anyone can prov...
Anonymous
Can you put the same data in a power bi file and show the expected results as well in the reply?
You save the file in OneDrive or Google Drive and share the link here
As you can see every location has target (Attendees), Take a example of Motor City it has the range of Attendees, every incremental attendees the location achieve so the commission will increase.
Through this table I want to calculate the commission for each Location:
For example Motorcity has achieve 711 Attendess so the commission would be 750.