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

  • 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.

3 Replies

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