Forum Discussion
Dynamically exclude blank values
HI PBI Community, I have the following issue My data is structured as followed, I have one column with many different Brands (>100), one column with different products (>500) and one column wit...
Whitewater100
Solution Sage
Solution SageHi:
You can use DIVIDE Function. It skips over missing numerator or denominators.
Index = DIVIDE[Comp Price], [Nivea Price])
you can also add your own replacment when a divide by zero causes an error.
index = DIVIDE[Comp Price], [Nivea Price], [avg price])
Hope this helps..