Table Column headers based on measure

[kleighton]

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 instead of +1, +2,+3 etc. For example, i could use a measure to return the desired name.

TMN+2 = (Format(EOMONTH(TODAY(),+2),"MMM"))&" " & "Bal."

Is there any way to use dynamic values or measures as column header values??

[v-xiaotang]

Hi @kleighton 

Thanks for reaching out to us.

You can refer to this solution, Solved: Re: Dynamic column header in Matrix - Microsoft Power BI Community

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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]

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?