Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

o59393

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

Submitted by Post Prodigy on ‎09-17-2023 05:38 PM

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.

Status: Investigating
See more ideas labeled with:
21 Comments (21 New)
Comments
o59393
Post Prodigy
Post Prodigy
‎09-18-2023 02:49 PM

If you are having this issue please comment below.

 

Thanks.

Anonymous
Not applicable
‎09-19-2023 02:10 AM

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
Not applicable
‎09-19-2023 06:38 AM

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
Not applicable
‎09-19-2023 06:59 AM

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
Post Prodigy
Post Prodigy
‎09-19-2023 08:37 AM

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

Anonymous
Not applicable
‎09-19-2023 11:11 PM

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
Regular Visitor
‎09-20-2023 03:53 PM

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
Post Prodigy
Post Prodigy
‎09-20-2023 04:16 PM

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

 

@Anonymous this issue is happenning to multiple users. 

Judith_de_Jong
Regular Visitor
‎09-21-2023 03:04 AM

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
Regular Visitor
‎09-21-2023 07:25 PM

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.

Idea Statuses