Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
B_kaydo
Advocate I
Advocate I

Prevent power bi from copy paste dax formulas when clicking on column columns

Hello everyone,

I have noticed that in the "Tables" panel, when I click on a created column PowerBi seems to copy it and if I click on another created column, it pastes it on another column. The issue happens whenever I click on a  column created by a formula, be it a table or a column.

It only happens when I click on the column, not when I select it in right panel, is it a normal feature ? Is there a way to turn it off ?

If it feels unclear let me know.

 

Thanks for the help

5 REPLIES 5
matthewstainsby
Frequent Visitor

Did this ever get resolved? I'm facing the same issue and its so annoying!!

WPP
New Member

I have the same issue. It's incredibly annoying as I have to close (without saving) the file en reopen it because I cannot undo the 'paste' and whatever DAX was supposed to be in the column is gone. 
I hope this is fixed soon as it has been going on for a while. 

The sole solution I have at the moment is to press "Esc" everytime I select a column to prevent the copying but if I ever forget it I risk losing the formulas

v-yiruan-msft
Community Support
Community Support

Hi @B_kaydo ,

I hope this message finds you well. I understand that you’re encountering an issue where the formula from a previously created calculated column seems to be copied when you create a new one. 

To assist you effectively, could you please provide a detailed step-by-step description of the process you’re following, ideally accompanied by a .gif illustrating the issue? This will help me understand the problem more clearly and guide you to a solution. Additionally, knowing the version of your Power BI Desktop could be crucial in diagnosing the issue accurately.

Thank you for reaching out, and I look forward to your response.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hello @v-yiruan-msft  sorry for the late answer
I will post printscreen of what I do/what I see, hope it will make it clearer :

I am in the table panel, selecting a column :

B_kaydo_0-1712062941626.png

I then select another column that I created, here it is "profit amount"

B_kaydo_1-1712062990740.png

 

Now, if I just select the column to the left of the one I selected, here is what I see :

B_kaydo_2-1712063055036.png

To translate, the box says that I can rename my column, as there is already a column with this name.

 

Just clicking the header has selected the whole formula and copy it, and if I click on another column it pastes it automatically, in the case of columns it doesn't overwite the formula, but for created tables it does if I am not careful

PowerBiCapture.gif

I also share a gif, hope it makes it clearer

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.