Dynamic change column name according current month - DAX or Power Query

[Hernán]

Hello everyone!

I hope you are doing great!

I have working in a table that it going to change every current month.

Image1. Table with the column name M+1 +M+2...M+n

Current table

Currently, I changed the column name thus:

Image2. Manual rename change for columns:

Columns renamed

Eg: If the current month is november, 2022, thus:

M+1 will be =December, 2022, M+2 will be = January, 2023... thus M+12 will be November, 2023

Eg: If The next month will be December, 2022 thus:

M+1 will be January, 2023, M+2 will be = February, 2022... M+12 will be December, 2023

How can I change it dynamically?, How can I use DAX or Power Query for to achieve that rename in the columns?

I expected:

Column names that I expected

Attached:

• pbix
• input data

Thank you so much for your help!

Regards,

Hernán Montoya

[Hernán]

Hello @v-yangliu-msft  thank you for your reply!

The solution you sent me isn't useful for my case. Thank you for the recommendation!.

Do you know if is possible to create a calendar table and associate future month with a specific column name or something similar?

Eg. If I create a calendar table and I use a similar function as DATEADD but in the future for to create to relationship between future months and my columns name (M+1 = current month + 1 futuremonth, M+2 = current month + 2 future months ...)

Thank you so much for your help!

Best regards,

Hernán Montoya

[v-yangliu-msft]

Hi  @Hernán ,

You cannot have dynamic names for a measure or column. But you can have dynamically measures to be displayed in a table visuals. Basically the field will change based on the measure you selected in a slicer. 

Dynamic Measure Selection in Power BI - Visual BI Solutions

28 - Change Column name Dynamically on Visuals in Power Bi - YouTube

Best Regards,

Liu Yang

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