Getting rename error on each calculated column in power BI desktop

[sb48846]

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")

Column Change to Table Name:

[cpfipowerbiuser]

i am also experiencing the same issue

[sb48846]

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.

[Joe_Barry]

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.

[sb48846]

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

[Joe_Barry]

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... 

[Joe_Barry · Accepted solution]

Maybe install January again until they fix the issue

[Joe_Barry]

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