Dynamic Column Header Names based month

[gtrthang]

I have a SQL data source that has relationships activities that will happen for various months.  The data source has a separate column for the previous 11 months, current month, and 23 future months (see example below), simular to a matrix.  Instead of displaying "Current Month" or "Current Month -1" I'd like to display the actual month/year as column headers in a table.  Any suggestions?  I could create a line in the data source to include the month's name, but not sure if that could be used.

Note:  I have used a reformated data source and have displayed as a Matrix.  The issue is I have about 30 columns that have to be displayed with the month information, so the lack of scrolling of the non-summarized fields presents an issue for the Matrix.

Thank you

[MFelix · Accepted solution]

Hi @gtrthang ,

On the query Editor select the RequestID column and unpivot other columns:

Now add the following column:

if [Attribute] = "CURRENT_MONTH" then
  Date.StartOfMonth(DateTime.LocalNow())
else if Text.Contains([Attribute], "MINUS") then
  Date.StartOfMonth(Date.AddMonths(DateTime.LocalNow(), - 1))
else
  Date.StartOfMonth(Date.AddMonths(DateTime.LocalNow(), Number.FromText(Text.End([Attribute], 2))))

Now you can use the column in your visualizations.

See PBIX file attach.