Forum Discussion
Crobby
4 years agoRegular Visitor
Custom conditional formatting comparing values
I am hoping you may be able to assist in working out this conditional formatting. The picture you see is the data taken from AAS (Azure Analytics Services). All the measure are created usin...
Crobby
4 years agoRegular Visitor
Hi amitchandak Can you explain this line and why it is used
var _slast = calculate(Table[Shelfspace],filter( allselected(Table), Table[Date] = _max2))
i am facing few issues in particular cases.
amitchandak
4 years agoSuper User
Crobby , is this a measure Shelf_Analytics[Shelfspace] ?
if not use some aggregation
var _slast = calculate(sum(Shelf_Analytics[Shelfspace]),filter( allselected(Shelf_Analytics), Shelf_Analytics[SMFeedback_Date] = _max2))
in case you are looking for column replace max with earlier and you can remove allselected from tbale