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:
Thank you Thomson! There's only one thing left, in the column 'Difference' are also negative values like -0,28. So with the expression "MIN" he takes not the value closest to zero but the lowest value (which is -0,28).
-0,28
-0,13
-0,1
-0,5
-0,01
0,1
0,14
etc.
Any idea for this?
wrote:
Any idea for this?
Use the ABS function as originally suggested?
Sorry, made the function ABS(Measure) - 0,8 instead of ABS(Measure - 0,8).
This works great! Thank you very much for your help.