"Current Month" as column header (and previous months). Need to auto correct to actual month

[Philjon]

I'm trying to transform data so that it is more friendly to the end user. The data below is an example of what I have. I would like to convert the column headers to read current month plus prior months. It needs to be rolling 12 in the report because stocking decisions on items are base on historical data in the past 12 months.

part number	Current month	Current month  less 1	Current Month less 2	Current month less 3	Current month less 4	Current month less 5
1a1	0	2	0	1	3	1
1a2	4	4	2	3	0	5
1a3	0	0	0	0	0	1
1b1	2	0	0	0	0	0
1b2	1	1	1	3	0	2
1b3	0	1	2	5	4	3

Would like the headers to read - 

Part number

19-Apr

19-Mar

19-Feb

19-Jan

18-Dec

17-Dec

I can change the headers manually, but I need the report to show rolling 12 info and update automatically. 

Thanks for the help!

[Anonymous]

@Philjon 

Not sure if this is what you want, but I have a bar graph with a month year axis. I need this axis to show only as a rolling 12 month period (So as of now I have data till March 2019 and my axis shows only from March 2018-March 2019)

what I do is I have a rolling 12 column that looks as follows:

Last 12 Months = VAR MaxDateV = CALCULATE(MAX('Date'[Date]), FILTER(ALL('Date'), 'Date'[Date]=MAX('Date'[Date]))) VAR CalDateMaxDateDiff = DATEDIFF(MaxDateV, 'Date'[Date], MONTH) RETURN SWITCH(TRUE(), CalDateMaxDateDiff>=-12 && CalDateMaxDateDiff<=0, "Yes","No" )

Then for my bar graph, I choose visual level filter of this measure to be "Yes". So each time it would only show me the last 12 months. (Also, for me the part MAX('Date'[Date]) is a reference to the end date of the previous month which is 3/31/2019) - So my graph shows from March 2018 - March 2019.