Bug with September 2023 Version - DAX & CALCULATED COLUMNS NOT WORKING

[o59393]

Dear MSFT

Recently I've noticed that calculated column and dax measures s are going blank or unchanged after writing code.

Can you review this potential bug from September version? 

Thanks.

[o59393]

If you are having this issue please comment below.

Thanks.

[v-xiaoyan-msft]

Hi  @o59393 ,

Thanks for the feedback, can you provide detailed Power BI Desktop version information?
I wasn't able to reproduce your issue successfully, would you mind providing some screenshots to describe the issue, please be careful to hide sensitive information.

We'll get back to the product team as soon as it's acknowledged as an issue!
Thanks in advance!

Best regards.
Community Support Team_Caitlyn

[Anonymous]

Hi there,

Having the same issue, every time I try to change or edit a calculated column with errors it just throws back to origin with 0 error message.

[Anonymous]

I actually think my issue might be related to when using "Return" function.

It seems to not let me edit the space before the return function once it has been called once..

I tried to paste below the return function (expection of cause error) and that worked.. so maybe it is some kind of proofing when writing calculated columns that is the issue.

[o59393]

@v-xiaoyan-msft  Hi, it's the september version. If I add update a measure in a calculated column, it will undo it a reverse it to the original condition. This is not normal.

Thanks.

[v-xiaoyan-msft]

Hi  @o59393 ,

I got the news that you have opened a surpport ticket.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

Best regards.
Community Support Team_Caitlyn

[BigPicDeepDive]

I am having this issue as well.... If the calculation violates rules instead of displaying a dax error the formula which is written disappears and the report refreshes. Example: If writing a measure and forgetting to use SUM the formula just disappears. If trying to reference a measure in a Column, the formula just disappears. No error messages are being generated. It is INSANELY FRUSTRATING to have your formula's just disappear with no error message. Freaking Power BI has to be the only software that releases automatic updates without a proper QA man. Seriously. Worst development team on the planet.

[o59393]

@BigPicDeepDive  Exactly! if the measure/calculated column violates the rule (example circular dependency) or adding measure into a calculated column, the formula just disappears. 

@v-xiaoyan-msft this issue is happenning to multiple users. 

[Judith_de_Jong]

Same thing since today and I'm on the September version as well. Seems if I create a calculated column based on another calcultated columns which has a CALCULATE in it, it won't save the modifcations to the new calculated column. If I remove the calculate in the DAX in the other column, it does save the changes. 

[Alicia]

I have experienced this issue as well with the Sep 23 version when modifying an existing calculated column. The calculation was valid with no errors, the column populated with the correct data, but after leaving the DAX formula area my changes didn't save.