Problem with calculated column formula when recording

[Syndicate_Admin]

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:

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

Could someone tell me why this happens?

Thanks for the help!

Fred

[Syndicate_Admin · Accepted solution]

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.

[v-easonf-msft]

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

[Syndicate_Admin]

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