Forum Discussion

kleighton's avatar
kleighton
Icon for Helper II rankHelper II
4 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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))

kleighton's avatar
kleighton
Icon for Helper II rankHelper II
4 years ago

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?