Forum Discussion
Column by chosen dates
Hi, I want to create a table based on the last 2 dates from the selected date filter. If the filter is for the whole of September, then the table will show only the last 2 days 30.9 and ...
Guyakobov , Try a measure like
measure =
var _max =maxx(allselected(Date), Date[Date])
return
calculate([measure], filter(Date, date[date] >= _max-1, date[date]<=_max))
or
measure =
var _max =maxx(allselected(Date), Date[Date])
return
sumx(values(date[date]),if(max(date[date]) >= _max-1, max(date[date])<=_max , [meausre], blank()))
HI,
thank you for your reply!
I tried it, but I can not use measures as in column in the matrix table.