Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

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 t...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    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.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

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's avatar
v-easonf-msft
Community Support
4 years ago

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's avatar
    Syndicate_Admin
    Administrator
    4 years ago

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