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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sb48846
Frequent Visitor

Getting rename error on each calculated column in power BI desktop

Hi,

 

Recently i am seeing "Rename Column" error on each calculated column for every table in PBI dekstop file when i click on dax calcualted coumns in table view. I could not get the root cause of this error and some time column name automatically changing to Table name. I appreciate any help on it. 

 

Rename column Error on Date Check dax column once i moved from this column.

Date Check DAX function : 

Date Check = IF('Table - Calendar'[Date].[Date] <= TODAY()-3,"Y","N")

 

sb48846_0-1711017757571.png

 

 

Column Change to Table Name:

sb48846_1-1711018327744.png

 

1 ACCEPTED SOLUTION

Maybe install January again until they fix the issue



I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Learn about the Star Schema, it will solve many issues in Power BI!



Date tables help! Learn more



LinkedIn
Follow me on LinkedIn


View solution in original post

7 REPLIES 7
cpfipowerbiuser
Regular Visitor

i am also experiencing the same issue

sb48846
Frequent Visitor

Hi @Joe_Barry 

 

I have used DAX function to create table first:  Table - Calendar = Calendar( Date(2021, 1, 1), Date(2025,12,31)).

Do you mean i should not create "Date Check" column with following formula in date table?.  

Date Check = IF('Table - Calendar'[Date].[Date] <= TODAY()-3,"Y","N")

I am getting same error across alll calculated columns in other tables.

 

Thanks,

Suman.

Has your PBI Desktop been updated recently? Please check this, depending on your area you should have at least the Feb. 2024 version installed.  Check your version. File>About and it will tell you there.  Then Activate any preview features that you need File > Preview Features. Save the file and then restart.



I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Learn about the Star Schema, it will solve many issues in Power BI!



Date tables help! Learn more



LinkedIn
Follow me on LinkedIn


Yes, I have Feb version. Following preview features are there but still getting same error.

sb48846_0-1711023361478.png

 

I haven't seen behaviour like this before. It's quite difficult to help without seeing the PBIX.

To troubleshoot, have you tried copying the dataset to another new PBIX? Maybe just the date table and see if the issue still occurs. 

I just found this article too, https://community.fabric.microsoft.com/t5/Desktop/quot-The-name-x-is-already-used-for-a-column-on-ta...

 

It seems that there is an issue with the February release, possible solution https://community.fabric.microsoft.com/t5/Desktop/quot-The-name-x-is-already-used-for-a-column-on-ta... 



I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Learn about the Star Schema, it will solve many issues in Power BI!



Date tables help! Learn more



LinkedIn
Follow me on LinkedIn


Maybe install January again until they fix the issue



I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Learn about the Star Schema, it will solve many issues in Power BI!



Date tables help! Learn more



LinkedIn
Follow me on LinkedIn


Joe_Barry
Solution Sage
Solution Sage

Hi @sb48846 

 

Calendar is a Table function and won't create a column as a conditional column CALENDAR function (DAX) - DAX | Microsoft Learn

 

Thanks

Joe



I hope my answer helped solve your question. Please give it a kudos or mark it as a solution to help other users find it.



Learn about the Star Schema, it will solve many issues in Power BI!



Date tables help! Learn more



LinkedIn
Follow me on LinkedIn


Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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