Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
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
Icon for Administrator rankAdministrator
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
    Icon for Community Support rankCommunity 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
      Icon for Administrator rankAdministrator
      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!!!