Forum Discussion

phchu1226's avatar
phchu1226
Helper IV
4 years ago

Issue on rename column dynamically

Hi all,   Refer to this post: https://community.powerbi.com/t5/Desktop/Auto-renaming-columns-based-on-value-in-another-table/m-p/79018   I am able to rename the column based on current date, i....
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.

phchu1226's avatar
phchu1226
Helper IV
4 years ago

Hi Anonymous,

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.

 

  • phchu1226's avatar
    phchu1226
    Helper IV
    4 years ago

    Anonymous,

     

    excuse me, is there any update?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.