HELP please, Multiple errors in my formulas

[Anonymous]

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?

[Anonymous]

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]

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]

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

[littlemojopuppy]

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.