Forum Discussion
Price Change Filter
I have been tasked to see if there is a way (formula) in Power BI that would allow users to see only items that had a predetermined price change over the prior period over a set price...they say a 3%...
So now that I am mulling this over, if the filter had values of "0.5%", "1%", "1.5%" etc....what would happen if any of the changes are not exactly "0.5%", "1%", "1.5%" etc. For instance my fear is if a results was a 1.15% change, would the filter exclude those items since there is not matching filter value? Thoughts?
That's why your calc column logic creates buckets:
If([PriceChange]<=.005,"<=.05%",If(and([PriceChange]>.005,[PriceChange]<=.01),".05-1%,...)
However, with this said, I wonder if you could use a numeric range slicer using your actual percentage change column.
If([PriceChange]<=.005,"<=.05%",If(and([PriceChange]>.005,[PriceChange]<=.01),".05-1%,...)
However, with this said, I wonder if you could use a numeric range slicer using your actual percentage change column.