Dynamic Date Column name

[UnknownUser32]

So my problem is as follows:

I generated a matrix where I want to compare values from this month against the month bevore and the value of last year. 
In this matrix I have the absolute difference, this months value and the value of last month.
I have a slicer on the side specifying the Month I want to look at.

Now I would like to change the column names to the Month name. (eg if I want to look at the values of July I would like to have this months value as a column name as Value of July 2025 and the Previous moth should show Value of June 2025 while the last years value should show Value of June 2024).

If I use parameters for this and try to work in a funktion in the name giving it does not accept the filter context of the slicer. I am able to use TODAY(), but then again it does not accept the filter context (for obvious reasons as it shows todays month, namely November).

Does somebody have a solution for this?

Thank you in advance!

[v-sgandrathi]

Hi @UnknownUser32,

Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.

Thank you.

[UnknownUser32]

Hi @v-sgandrathi ,
Thank you for the follow up - I have used this solution, as there is no other way, thank you 🙂

[v-sgandrathi · Accepted solution]

Hi @UnknownUser32,

Thank you for providing the details and sample structure, it’s very helpful. Currently, Power BI does not support dynamically renaming matrix column headers based on slicer selections (for instance, changing the column name to “Value of August 2025” or “Value of July 2025” automatically). While measures like your last_month using PARALLELPERIOD will update values according to the month slicer, the column headers themselves remain static.

A typical workaround is to use generic measure or column names in the matrix (such as Current month, Previous month, Last year) and display the selected month and year using dynamic text in card visuals above the matrix. For example, you can create measures like:
CurrentMonthLabel = "Value of " & FORMAT(SELECTEDVALUE('Calendar'[CALENDAR_ID]), "MMMM yyyy")
PrevMonthLabel = "Value of " & FORMAT(EOMONTH(SELECTEDVALUE('Calendar'[CALENDAR_ID]), -1), "MMMM yyyy")
and use these cards as “pseudo-headers.” When the slicer changes from August to September, these cards will update automatically to show “Value of August 2025 vs Value of July 2025”. For dynamic labels directly in the matrix, custom visuals like Inforiver Matrix or advanced setups with field parameters or calculation groups may be needed, as the default matrix does not support this feature yet.

Thank you.

[UnknownUser32]

I generated an example and can show you the sreenshots, but cannot uplpad files due to company restrictions:

So this is my main issue. In the Screenshot below I show the matrix and a SLicer of the month showing me the numbers of this month and the month before. I would like the columns to be named August and July in that case and when I jump to September they should be named September and August.

I used this data as an example:

Date Friday, January 31, 2025 Friday, February 28, 2025 Monday, March 31, 2025 Wednesday, April 30, 2025 Saturday, May 31, 2025 Monday, June 30, 2025 Thursday, July 31, 2025 Sunday, August 31, 2025 Tuesday, September 30, 2025 Friday, October 31, 2025 Sunday, November 30, 2025 Wednesday, December 31, 2025 Friday, January 31, 2025 Friday, February 28, 2025 Monday, March 31, 2025 Wednesday, April 30, 2025 Saturday, May 31, 2025 Monday, June 30, 2025 Thursday, July 31, 2025 Sunday, August 31, 2025 Tuesday, September 30, 2025 Friday, October 31, 2025 Sunday, November 30, 2025 Wednesday, December 31, 2025 Friday, January 31, 2025 Friday, February 28, 2025 Monday, March 31, 2025 Wednesday, April 30, 2025 Saturday, May 31, 2025 Monday, June 30, 2025 Thursday, July 31, 2025 Sunday, August 31, 2025 Tuesday, September 30, 2025 Friday, October 31, 2025 Sunday, November 30, 2025 Wednesday, December 31, 2025

PlantID 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3

Last Inventory 214 215 300 254 190 841 150 241 12 518 252 25 152 599 25 215 412 651 231 125 145 213 214 52 300 254 190 841 150 241 12 518 252 25 152 599

I used this as a calendar dimension:

CALENDAR_ID
Friday, February 28, 2025
Thursday, February 27, 2025
Wednesday, February 26, 2025
Tuesday, February 25, 2025
Monday, February 24, 2025
Sunday, February 23, 2025
Saturday, February 22, 2025
Friday, February 21, 2025
Thursday, February 20, 2025
Wednesday, February 19, 2025
Tuesday, February 18, 2025
Monday, February 17, 2025
Sunday, February 16, 2025
Saturday, February 15, 2025
Friday, February 14, 2025
Thursday, February 13, 2025
Wednesday, February 12, 2025
Tuesday, February 11, 2025
Monday, February 10, 2025
Sunday, February 9, 2025
Saturday, February 8, 2025
Friday, February 7, 2025
Thursday, February 6, 2025
Wednesday, February 5, 2025
Tuesday, February 4, 2025
Monday, February 3, 2025
Sunday, February 2, 2025
Saturday, February 1, 2025
Monday, March 31, 2025
Sunday, March 30, 2025
Saturday, March 29, 2025
Friday, March 28, 2025
Thursday, March 27, 2025
Wednesday, March 26, 2025
Tuesday, March 25, 2025
Monday, March 24, 2025
Sunday, March 23, 2025
Saturday, March 22, 2025
Friday, March 21, 2025
Thursday, March 20, 2025
Wednesday, March 19, 2025
Tuesday, March 18, 2025
Monday, March 17, 2025
Sunday, March 16, 2025
Saturday, March 15, 2025
Friday, March 14, 2025
Thursday, March 13, 2025
Wednesday, March 12, 2025
Tuesday, March 11, 2025
Monday, March 10, 2025
Sunday, March 9, 2025
Saturday, March 8, 2025
Friday, March 7, 2025
Thursday, March 6, 2025
Wednesday, March 5, 2025
Tuesday, March 4, 2025
Monday, March 3, 2025
Sunday, March 2, 2025
Saturday, March 1, 2025
Thursday, January 1, 2026
Friday, January 31, 2025
Thursday, January 30, 2025
Wednesday, January 29, 2025
Tuesday, January 28, 2025
Monday, January 27, 2025
Sunday, January 26, 2025
Saturday, January 25, 2025
Friday, January 24, 2025
Thursday, January 23, 2025
Wednesday, January 22, 2025
Tuesday, January 21, 2025
Monday, January 20, 2025
Sunday, January 19, 2025
Saturday, January 18, 2025
Friday, January 17, 2025
Thursday, January 16, 2025
Wednesday, January 15, 2025
Tuesday, January 14, 2025
Monday, January 13, 2025
Sunday, January 12, 2025
Saturday, January 11, 2025
Friday, January 10, 2025
Thursday, January 9, 2025
Wednesday, January 8, 2025
Tuesday, January 7, 2025
Monday, January 6, 2025
Sunday, January 5, 2025
Saturday, January 4, 2025
Friday, January 3, 2025
Thursday, January 2, 2025
Wednesday, January 1, 2025
Saturday, May 31, 2025
Friday, May 30, 2025
Thursday, May 29, 2025
Wednesday, May 28, 2025
Tuesday, May 27, 2025
Monday, May 26, 2025
Sunday, May 25, 2025
Saturday, May 24, 2025
Friday, May 23, 2025
Thursday, May 22, 2025
Wednesday, May 21, 2025
Tuesday, May 20, 2025
Monday, May 19, 2025
Sunday, May 18, 2025
Saturday, May 17, 2025
Friday, May 16, 2025
Thursday, May 15, 2025
Wednesday, May 14, 2025
Tuesday, May 13, 2025
Monday, May 12, 2025
Sunday, May 11, 2025
Saturday, May 10, 2025
Friday, May 9, 2025
Thursday, May 8, 2025
Wednesday, May 7, 2025
Tuesday, May 6, 2025
Monday, May 5, 2025
Sunday, May 4, 2025
Saturday, May 3, 2025
Friday, May 2, 2025
Thursday, May 1, 2025
Wednesday, April 30, 2025
Tuesday, April 29, 2025
Monday, April 28, 2025
Sunday, April 27, 2025
Saturday, April 26, 2025
Friday, April 25, 2025
Thursday, April 24, 2025
Wednesday, April 23, 2025
Tuesday, April 22, 2025
Monday, April 21, 2025
Sunday, April 20, 2025
Saturday, April 19, 2025
Friday, April 18, 2025
Thursday, April 17, 2025
Wednesday, April 16, 2025
Tuesday, April 15, 2025
Monday, April 14, 2025
Sunday, April 13, 2025
Saturday, April 12, 2025
Friday, April 11, 2025
Thursday, April 10, 2025
Wednesday, April 9, 2025
Tuesday, April 8, 2025
Monday, April 7, 2025
Sunday, April 6, 2025
Saturday, April 5, 2025
Friday, April 4, 2025
Thursday, April 3, 2025
Wednesday, April 2, 2025
Tuesday, April 1, 2025
Monday, June 30, 2025
Sunday, June 29, 2025
Saturday, June 28, 2025
Friday, June 27, 2025
Thursday, June 26, 2025
Wednesday, June 25, 2025
Tuesday, June 24, 2025
Monday, June 23, 2025
Sunday, June 22, 2025
Saturday, June 21, 2025
Friday, June 20, 2025
Thursday, June 19, 2025
Wednesday, June 18, 2025
Tuesday, June 17, 2025
Monday, June 16, 2025
Sunday, June 15, 2025
Saturday, June 14, 2025
Friday, June 13, 2025
Thursday, June 12, 2025
Wednesday, June 11, 2025
Tuesday, June 10, 2025
Monday, June 9, 2025
Sunday, June 8, 2025
Saturday, June 7, 2025
Friday, June 6, 2025
Thursday, June 5, 2025
Wednesday, June 4, 2025
Tuesday, June 3, 2025
Monday, June 2, 2025
Sunday, June 1, 2025
Friday, October 31, 2025
Thursday, October 30, 2025
Wednesday, October 29, 2025
Tuesday, October 28, 2025
Monday, October 27, 2025
Sunday, October 26, 2025
Saturday, October 25, 2025
Friday, October 24, 2025
Thursday, October 23, 2025
Wednesday, October 22, 2025
Tuesday, October 21, 2025
Monday, October 20, 2025
Sunday, October 19, 2025
Saturday, October 18, 2025
Friday, October 17, 2025
Thursday, October 16, 2025
Wednesday, October 15, 2025
Tuesday, October 14, 2025
Monday, October 13, 2025
Sunday, October 12, 2025
Saturday, October 11, 2025
Friday, October 10, 2025
Thursday, October 9, 2025
Wednesday, October 8, 2025
Tuesday, October 7, 2025
Monday, October 6, 2025
Sunday, October 5, 2025
Saturday, October 4, 2025
Friday, October 3, 2025
Thursday, October 2, 2025
Wednesday, October 1, 2025
Wednesday, December 31, 2025
Tuesday, December 30, 2025
Monday, December 29, 2025
Sunday, December 28, 2025
Saturday, December 27, 2025
Friday, December 26, 2025
Thursday, December 25, 2025
Wednesday, December 24, 2025
Tuesday, December 23, 2025
Monday, December 22, 2025
Sunday, December 21, 2025
Saturday, December 20, 2025
Friday, December 19, 2025
Thursday, December 18, 2025
Wednesday, December 17, 2025
Tuesday, December 16, 2025
Monday, December 15, 2025
Sunday, December 14, 2025
Saturday, December 13, 2025
Friday, December 12, 2025
Thursday, December 11, 2025
Wednesday, December 10, 2025
Tuesday, December 9, 2025
Monday, December 8, 2025
Sunday, December 7, 2025
Saturday, December 6, 2025
Friday, December 5, 2025
Thursday, December 4, 2025
Wednesday, December 3, 2025
Tuesday, December 2, 2025
Monday, December 1, 2025
Sunday, November 30, 2025
Saturday, November 29, 2025
Friday, November 28, 2025
Thursday, November 27, 2025
Wednesday, November 26, 2025
Tuesday, November 25, 2025
Monday, November 24, 2025
Sunday, November 23, 2025
Saturday, November 22, 2025
Friday, November 21, 2025
Thursday, November 20, 2025
Wednesday, November 19, 2025
Tuesday, November 18, 2025
Monday, November 17, 2025
Sunday, November 16, 2025
Saturday, November 15, 2025
Friday, November 14, 2025
Thursday, November 13, 2025
Wednesday, November 12, 2025
Tuesday, November 11, 2025
Monday, November 10, 2025
Sunday, November 9, 2025
Saturday, November 8, 2025
Friday, November 7, 2025
Thursday, November 6, 2025
Wednesday, November 5, 2025
Tuesday, November 4, 2025
Monday, November 3, 2025
Sunday, November 2, 2025
Saturday, November 1, 2025
Tuesday, September 30, 2025
Monday, September 29, 2025
Sunday, September 28, 2025
Saturday, September 27, 2025
Friday, September 26, 2025
Thursday, September 25, 2025
Wednesday, September 24, 2025
Tuesday, September 23, 2025
Monday, September 22, 2025
Sunday, September 21, 2025
Saturday, September 20, 2025
Friday, September 19, 2025
Thursday, September 18, 2025
Wednesday, September 17, 2025
Tuesday, September 16, 2025
Monday, September 15, 2025
Sunday, September 14, 2025
Saturday, September 13, 2025
Friday, September 12, 2025
Thursday, September 11, 2025
Wednesday, September 10, 2025
Tuesday, September 9, 2025
Monday, September 8, 2025
Sunday, September 7, 2025
Saturday, September 6, 2025
Friday, September 5, 2025
Thursday, September 4, 2025
Wednesday, September 3, 2025
Tuesday, September 2, 2025
Monday, September 1, 2025
Sunday, August 31, 2025
Saturday, August 30, 2025
Friday, August 29, 2025
Thursday, August 28, 2025
Wednesday, August 27, 2025
Tuesday, August 26, 2025
Monday, August 25, 2025
Sunday, August 24, 2025
Saturday, August 23, 2025
Friday, August 22, 2025
Thursday, August 21, 2025
Wednesday, August 20, 2025
Tuesday, August 19, 2025
Monday, August 18, 2025
Sunday, August 17, 2025
Saturday, August 16, 2025
Friday, August 15, 2025
Thursday, August 14, 2025
Wednesday, August 13, 2025
Tuesday, August 12, 2025
Monday, August 11, 2025
Sunday, August 10, 2025
Saturday, August 9, 2025
Friday, August 8, 2025
Thursday, August 7, 2025
Wednesday, August 6, 2025
Tuesday, August 5, 2025
Monday, August 4, 2025
Sunday, August 3, 2025
Saturday, August 2, 2025
Friday, August 1, 2025
Thursday, July 31, 2025
Wednesday, July 30, 2025
Tuesday, July 29, 2025
Monday, July 28, 2025
Sunday, July 27, 2025
Saturday, July 26, 2025
Friday, July 25, 2025
Thursday, July 24, 2025
Wednesday, July 23, 2025
Tuesday, July 22, 2025
Monday, July 21, 2025
Sunday, July 20, 2025
Saturday, July 19, 2025
Friday, July 18, 2025
Thursday, July 17, 2025
Wednesday, July 16, 2025
Tuesday, July 15, 2025
Monday, July 14, 2025
Sunday, July 13, 2025
Saturday, July 12, 2025
Friday, July 11, 2025
Thursday, July 10, 2025
Wednesday, July 9, 2025
Tuesday, July 8, 2025
Monday, July 7, 2025
Sunday, July 6, 2025
Saturday, July 5, 2025
Friday, July 4, 2025
Thursday, July 3, 2025
Wednesday, July 2, 2025
Tuesday, July 1, 2025

This is the dax I used to calculate the last month:
last_month =
Calculate(
SUM(Inventory[Last Inventory]),
PARALLELPERIOD('Calendar'[CALENDAR_ID], -1,MONTH)
)

[UnknownUser32]

@123abc 

[123abc]

can you please share the sample data or sample pbix file ?