Forum Discussion
Month filter
Hi all, I created a bar chart that shows data of all previous months when I filter on one specific month. This is properly working with an unconnected date table. The issue is wh...
Anonymous , Try like
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -3) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))