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
Syndicate_Admin
Administrator
Administrator

Problem with calculated column formula when recording

Good morning

I wanted to check if someone when recording a file the program modifies the formula and shows them an error.

I have the following formula in a calculated column that works OK:

flitvak_0-1634824106101.png

When I save the file, Power Bi automatically modifies the formula (changes the "comma" to a "period") and stops showing me the result:

flitvak_1-1634824337877.png

Could someone tell me why this happens?

Thanks for the help!

Fred

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

I was doing a couple of tests and found a temporary solution since it seems to me that the ones described in the message above is a Power BI bug.

So that I do not automatically change the program from "comma" to "period", create a new calculated column that does not have any formula.

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

I was doing a couple of tests and found a temporary solution since it seems to me that the ones described in the message above is a Power BI bug.

So that I do not automatically change the program from "comma" to "period", create a new calculated column that does not have any formula.

Hi, @Syndicate_Admin 

Thank you for sharing your workaround here.

By the way, when you create the new calculated column,you can try the 'switch' function to replace 'if'

e.g

Fecha para finaciero 2 =
VAR a =
    FORMAT ( FAC_QueryPeridos[Fecha de entrega], "dddd" )
VAR b =
    SWITCH (
        a,
        "Lunes", FAC_QueryPeridos[Fecha de entrega] - 3,
        "Mates", FAC_QueryPeridos[Fecha de entrega] - 1,
        .............other conditions,
        "Domingo",FAC_QueryPeridos[Fecha de entrega] - 2
    )
RETURN
    b

 

Best Regards,
Community Support Team _ Eason

Thanks for the suggestion! The formula is much neater!!!

The thing is, I don't think that's why I changed the character from a "," to a "."

Best regards!!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors