when bookmark is applied, part of the measure expression gets ignored
Hello experts.
My measure is a difference between: sales on max date per warehouse - sales on the same date last year per warehouse (using date(addyears(date,-1)) for this)
My bookmark is {<[date]={"=Num([date])=Num(Max(ALL [date])) "}>} so as to present data on the max date to come across the data.
When the bookmark is applied, this part of my measure get ignored: ales on max date per warehouse - sales on the same date last year per warehouse (using date(addyears(date,-1)) for this)
When not applied, the differences are counted well.