Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Issue on rename column dynamically

Hi all,


Refer to this post:


I am able to rename the column based on current date,

i.e today = 29/1,  week0 = 28/1 or before

                             week1 = 29/1 - 4/2

                             week2 =5/2 - 11/2


Everything is fine before moving to next day...

The renaming part is fine, the column name is renamed correctly but error occur in the "Values" tab as it cant find the columns after renaming..



Any suggestion for fixing this issue or other alternatives to achieve what I need? Thank you in advance!!




Community Support
Community Support

Hi @phchu1226 ,

you are using the column that’s being renamed, but in your Power BI model, you’ve never renamed it. For example, the original column name is “Passengers”, and you’ve never renamed it. Now it’s being renamed at the data source to “NumberOfPasssengers”. In this case, after the column has been renamed at source, your Power BI refresh will be successful, but some visualisations will fail to load.

To solve that, you have two options.

  • The easy one would be to rename, in your Power BI model, the renamed-at-source field, to its original name. In the example above, this means renaming “NumberOfPasssengers” back to “Passengers”. If you do that, all visualisations and DAX calculations will become valid again.
  • The other option is to go over all invalid visualisations and DAX calculations, and edit them to use the new field name.


Best Regards

Community Support Team _ Polly


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

Hi @v-rongtiep-msft,

I knew that I can rename back to the original column name to solve this issue..

However, what I want to do is to rename the column name based on the date,

e.g. today is 8/2, the column should be look like below:



Is it possible to do so?? Thanks.




excuse me, is there any update?

Hi @phchu1226 ,

I have found a simuliar post, please refer to it to see if it helps you.

ow to rename column name as current Date dynamically? 


let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwtFTSUTJVitUhgmOElWMB5BgaEMuzQOPEAgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Year = _t, #"Value " = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Year", Int64.Type}, {"Value ", Int64.Type}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type", { { "Year", let currentDateTime = DateTimeZone.LocalNow(), currentYear = Number.ToText( Date.Year( currentDateTime ) ), currentMonth = Date.MonthName( currentDateTime ) in currentYear & "-" & currentMonth } } ) in #"Renamed Columns"Best Regards
Community Support Team _ Polly




Best Regards

Community Support Team _ Polly


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


Super User
Super User

@phchu1226 , Create a column in table and use

Switch( True(),

[Date] < today() -1 , "Week 0" ,

[Date] > today() , "Week " & quotient(datediff([Date], Today(), Day),7) +1


Hi @amitchandak,


I had tried this DAX, the result is not what I expected.

I just want to rename the column name based on date.



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors