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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Shiroyasha
New Member

Columnas calculadas se sobre escriben

Saludos.

 

Estoy trabajando con  Power BI Desktop y  me he percatado que cuando estoy trabajando con columnas calculadas y la selecciono desde el encabezado al pasar a otro encabezado de otra columna calculada me sobreescribe la columna.¿ Alguien sabra a que se debe esto? No logro detectar si se debe a la configuracion de la aplicacion o simplemente es algo que no se puede evitar.  Me di cuenta de que lo que pasa realmente pasa es que al seleccionar la columna copia la formula y al seleccionar otra columna la pega automaticamente lo que me genera errores. Es algo desesperante pero sigo buscando soluciones. 

 

1 ACCEPTED SOLUTION
v-yohua-msft
Community Support
Community Support

Hi, @Shiroyasha 

 

Make sure Power BI Desktop is up to date. Power BI Desktop is updated monthly with new features and bug fixes. An outdated version may contain bugs that have been resolved in a newer version. For more information about updating Power BI Desktop, visit Power BI Desktop updates.

 

What's new in the latest Power BI update - Power BI | Microsoft Learn

 

When working with calculated columns, make sure that you use the appropriate method to select and navigate between columns. Clicking directly on the formula bar or using keyboard shortcuts, such as or keys, to navigate between columns can help avoid inadvertently copying and pasting formulas.

 

As a temporary workaround, try to avoid selecting the entire column header when using calculated columns. If you need to copy formulas from one calculated column to another, use the formula bar directly above the canvas to manually copy and paste the formulas. This approach should help prevent automatic overwriting of formulas.

 

You can try to reproduce the issue in a new Power BI Desktop file using a simple calculated column setting. This helps determine whether the issue is file-specific or more general application behavior. Make sure that no external utilities or clipboard managers are interfering with the operation of Power BI Desktop. Sometimes, third-party software can cause unexpected behavior in the app.

 

If there is still a problem, can you provide some screenshots of the problem?And don't give away your private information.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

View solution in original post

2 REPLIES 2
Shiroyasha
New Member

Saludos.

 

Muchas gracias por tu respuesta. Entiendo que el metodo adecuado es el que me indicas, efectivamente al realizar la seleccion desde el panel de columnas o directamente desde la columna no existe ningun problema, solo cambiare la forma en que seleccionaba. Queria estar seguro de que no era un problema de mi archivo o configuracion, tendre que prestar mas atencion al seleccionar los encabezados para evitar sobreescribir las formulas.

Excelente día. 

v-yohua-msft
Community Support
Community Support

Hi, @Shiroyasha 

 

Make sure Power BI Desktop is up to date. Power BI Desktop is updated monthly with new features and bug fixes. An outdated version may contain bugs that have been resolved in a newer version. For more information about updating Power BI Desktop, visit Power BI Desktop updates.

 

What's new in the latest Power BI update - Power BI | Microsoft Learn

 

When working with calculated columns, make sure that you use the appropriate method to select and navigate between columns. Clicking directly on the formula bar or using keyboard shortcuts, such as or keys, to navigate between columns can help avoid inadvertently copying and pasting formulas.

 

As a temporary workaround, try to avoid selecting the entire column header when using calculated columns. If you need to copy formulas from one calculated column to another, use the formula bar directly above the canvas to manually copy and paste the formulas. This approach should help prevent automatic overwriting of formulas.

 

You can try to reproduce the issue in a new Power BI Desktop file using a simple calculated column setting. This helps determine whether the issue is file-specific or more general application behavior. Make sure that no external utilities or clipboard managers are interfering with the operation of Power BI Desktop. Sometimes, third-party software can cause unexpected behavior in the app.

 

If there is still a problem, can you provide some screenshots of the problem?And don't give away your private information.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.