Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HELP please, Multiple errors in my formulas

Hi everyone, 

All of sudden, all my formulas seem to have an error in the parenthesis. I don't really know where it comes from, but it looks like this

 

Those were perfectly functional formulas before, and now the red sign appears in every calculated column or measure in my model.

Besides, I am not sure if this error is preventing Power Bi to run properly other new formulas I´m adding.

Do you know how can I solve this error please?

4 Replies

  • littlemojopuppy's avatar
    littlemojopuppy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous   What is the error?

    Also...did you know that you shouldn't need the if isblank part of the LOOKUPVALUE function.  It includes an alternate result for if none or more than one result is returned.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the recommendation of the LOOKUPVALUE function, it was very useful. I will change the formulas with that sintaxis.

    Regarding the error, that is the problem 😞 I am not sure where it comes from. All I know is that the red rigns are everywhere.

    By now everything works normal, but I am worried that those red lights can be afecting other formulas. I think it can be a problem of the power bi software or something similar. But I want make those red notifications disappear.

    Thanks in advance.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      HI Anonymous,

      What version of power bi desktop are you working on? Have you applied any update on the power bi desktop client recently? It will help if you share some more detailed information to test.

      How to Get Your Question Answered Quickly  

      Regards,

      Xiaoxin Sheng

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Xiaoxin

        I have recently downloaded this version of power Bi, trying to solve the problem but the error is still there.

        In one ocassion, this error showed

        "An error occurred while rendering the report" and I've been following the solutions in this thread,but again, nothing seems to work.

        I even opened the file in other device and everything works well, the error is gone. I am not sure if this is a problem of the computer itself.

         

        Thanks in advance