Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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
@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.
Hi Amit, here is a link to the file https://www.file.io/2ar2/download/vnasaZlP8CbZ
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |