Forum Discussion
Duplicate Column Name in table error without any duplicate names
- Anonymous2 years ago
Hi, amarlian
Your solution is great iluvaccounting1 . After my testing, this bug does exist in the new version. The main reason for this bug is that when we click on another column, we click on the original column again, and the corresponding formula is copied.I created a new table with summarize, and then created a new calculated column in this table:
When clicking on another column and then clicking on the original column, we get an error, and we find that the formula of the original new column has been replaced, as shown in the image below:
You can avoid this problem by clicking on these columns carefully. In addition, you can download an older version of Power BI to use.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
can you post some screen shots?
vanessafvg I'm having the same error on my models. It appears to be a glitch because it is doing it on all of my power bi files, in the calculated tables, which worked a week ago... Haven't been able to figure out a solution yet... I'll link my post below which includes screenshots. I didn't take screenshots of the duplicate name issue but it is giving me the same probelm as soon as I re-click back into the column.
https://community.fabric.microsoft.com/t5/Desktop/Updating-DAX-Expression-Causes-Errors-HELP/m-p/3736943#M1214672