Forum Discussion
Identifying Entries that Add Up to a Specific Value With Constraints
Hi,
I have scoured multiple forums but can’t seem to find a solution. Im looking for a way to do this in power query excel which is dynamic easily updateable. I want to just upload cvs with historical data.
On weekly basis I have to meet certain X enquiries with specific constraint of X conversion rate. Using historical data, I evaluate previous performance and make predictions. However, what I am looking for is a way to automate and simply this process. I’m looking for a solution where I enter enquiries target amount (which should only deviate +10% or -10%) and >= target conversion rate.
Find below example data. The enquiry target should = 58 or deviate +-10% and conversion rate of >= 2%. Its very important that the solution should also identify which campaigns meet these conditions. In this case following combined campaigns meet these conditions C to F.
I have seen solutions for excel using Solver function but its not really dynamic. Can someone help me with this?
1 Reply
Power Query is a lot of things, but "dynamic" is not one of them.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
