Change column name based on list

[MCDyna]

Hi Community,

I have a simple example file for my problem..

Two stores send me the same info, but with different column names. I have a table with the "old" names, and the "new" names I want them to transfer to.

What formula do I need to get this?

The sample file:

The link 

[Anonymous]

Hi @MCDyna ,

Currently we can only manually change the column name or table name.

There is a trick that you could create visuals for both new and old table then show different visuals based on specific condition.

https://www.linkedin.com/pulse/show-different-visuals-based-condition-power-bi-alina-fisher 

Best Regards,

Jay

[MCDyna]

Thanks Jay. 

Wouldn't a DAX script work in the form of:

take column 'location' and change it to 'city' & take column 'value' and change it to 'totals'

[Anonymous]

Hi @MCDyna ,

Value could be changed, but the column header could not.

You could refer this topic.

https://community.powerbi.com/t5/Desktop/Display-data-from-the-same-column-with-different-format/m-p... 

Best Regards,

Jay

[amitchandak]

@MCDyna ,The information you have provided is not making the problem clear to me. Can you please explain with an example?
Check if userelationship can help

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...
Appreciate your Kudos.

[MCDyna]

Hi Amit, here is a link to the file https://www.file.io/2ar2/download/vnasaZlP8CbZ