Forum Discussion
Solved
Search for closest value
Hello, I have a sheet with customers, sales and cumulative sales in % (sorted customers descending by sales). I want to make a measure which searches the closest value of sales for a given %. Let...
Make a calculated column like I suggested (for 80% you'd need 0.8 rather than 0.5) called difference, then make a measure like the below:
So you've got some measure, say, JarnosMeasure, and you want to find a result for this which is closest to 50%? Not a function I've used before so the syntax may be off, but something like Nearest = ABS([JarnosMeasure]-0.5) and then look to find the smallest value for this?