Forum Discussion
Change column name based on list
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:
5 Replies
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 helphttps://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi
Appreciate your Kudos.Hi Amit, here is a link to the file https://www.file.io/2ar2/download/vnasaZlP8CbZ
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
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'
Hi MCDyna ,
Value could be changed, but the column header could not.
You could refer this topic.
Best Regards,
Jay
