Sorry if this subject has already been up, but I dont know what terms or keywords I should search for. Please redirect me to the right one if it already has.
Im trying to find a method to hide “-100%” values if dates/years that dont have any data. See the two measure examples below.
What I would like to use
Δ %Rev LY = DIVIDE( [Sales] , [Sales LY Until Today] , BLANK() )
With the result looking like this
but ending up like this:
What I use now, but think is a mess and does the trick:
Δ %Rev LY =
OR ( ISBLANK ( [Sales] ), ISBLANK ( [Sales LY Until Today] ) ),
DIVIDE( [Sales] , [Sales LY Until Today] , BLANK() )
Is there some other way to write the code with less ISBLANK, OR and BLANK() ?