Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter Table Visual Based on Slicer Selection

Hello,   I have a table visual  on my report that is composed of columns from four different tables. One of my slicers is choosing from a list of dates, in the format YYMM, in whole number datatype...
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

measure =
var _max =maxx(allselected(Date), Date[YYMM])
return
calculate([measure],filter(all(Date),Date[YYMM]<=_max))