Updating DAX Expression Causes Errors!! HELP

[iluvaccounting1]

When I'm updating the DAX expressions in calculated tables, the new column I am creating is replaced by the table with which I am working in. This only happens after I write the expression and click out of the input field. This is happening in multipe models that I have built that have no relation to each other, see screenshots below of a test example. Is this a known glitch or is there a solution to this?

[vanessafvg]

has anything in your data changed?  have you checked that there isn't some form of duplication happening, because something that might have worked before and if its affecting all your models but the common denominator is your data, it might be that something has changed.   

summarize would work off your relationships, so to me and i could be wrong it looks like its unable to resolve a single value for your calculated column.

can you share a screenshot of your model, and what the relationships look like?

that will also guide you to see if there is a duplication thats unexpected.

[iluvaccounting1]

@vanessafvgnothing in my data has changed. i did check to see if there was any duplication and there hasn't been. i should have been more clear, when i said it is affecting all of my models i meant all of my power bi data sets, which are separate from one another. i have another sample data set i have new screenshots from as the problem continues to persist. as you can see from the screenshots below, i can create a calculated column in the calcualted table but when when i click into a different column and click back in, it replaces the calculated column with the table.

[iluvaccounting1 · Accepted solution]

Figured it out, it is a bug in the latest update. I installed the December 2023 version of PowerBI and it works.

[amitchandak]

@iluvaccounting1 , This can happen if you create a column in a table that is not Test. Or when you are creating a measure or Table

[iluvaccounting1]

@amitchandak So this happens whether the column is called "Test" or not. In this instance the calculated table is called test and the column I'm creating is called test, but if I was to change the names I'd still run into the same issue.