Forum Discussion
Table Column headers based on measure
Hi I have the following table showing current stock balance and the forceasts and balances over the next 3 months. I would like to change the column headers to use the dynamic Month name i...
kleighton , You can have measures like
next 3 and last 3 =
var _max = eomonth( today() ,3)
var _min = date(year(_max), month(_max)-6,1)
return
CALCULATE(SUM(Sales[Sales Amount]),filter(date, date[date] <=_max && date[date] >=_min))
HI, thanks for your reply!
My main question is regarding the table column names, how can i change them to show the dynamic month name? or is it even possible?