Hi everyone,
Is there a way to set a MAX value for a measure? I.e. the equivalent of Excel's =MIN(A1*A2),100).
I have a list of percentage variances against budget and some are massive eg 21,000%. Would be nice to show this as something like >100%, or similar.
I suspect I can do an IF('measure' > 100, ">100%", <measure>), but this might cause performance issues as I'd be doing calcs twice.
Thanks for any advice you may have.
(fyi using PowerPivot in Excel 2010)
Richard
Is there a way to set a MAX value for a measure? I.e. the equivalent of Excel's =MIN(A1*A2),100).
I have a list of percentage variances against budget and some are massive eg 21,000%. Would be nice to show this as something like >100%, or similar.
I suspect I can do an IF('measure' > 100, ">100%", <measure>), but this might cause performance issues as I'd be doing calcs twice.
Thanks for any advice you may have.
(fyi using PowerPivot in Excel 2010)
Richard