Forum Discussion
Dynamic (very!) column headers in matrix
Hello, I have an issue with column headers in matrix. I need to show 12 months - dynamicly changed. That is not a big issue - I can use a month name from the calendar as a column. But there are t...
AnetaK , Create slicer on an independent date table, then you can have measure like
//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -12) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI