Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have defined 2 below variables:
vTYMTDSales = Sum({<NUMDate = {43466}>}[Sales Qty])
vLYMTDSales = Sum({<NUMDate = {43101}>}[Sales Qty])
And create another variable called “vCompare”.
Is both expression, taken calculated value or recalculate the above variable.
vCompare = $(=If($(vTYMTDSales) - $(vLYMTDSales) > 0,0,1))
vCompare = =If($(vTYMTDSales) - $(vLYMTDSales) > 0,0,1)