topic Re: HELP please, Multiple errors in my formulas in DAX Commands and Tips

HELP please, Multiple errors in my formulas

Anonymous — Fri, 12 Aug 2022 12:46:33 GMT

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?

Re: HELP please, Multiple errors in my formulas

littlemojopuppy — Sun, 14 Aug 2022 19:09:07 GMT

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.

Re: HELP please, Multiple errors in my formulas

Anonymous — Mon, 15 Aug 2022 03:29:39 GMT

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.

Re: HELP please, Multiple errors in my formulas

Anonymous — Tue, 30 Aug 2022 08:25:51 GMT

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

Re: HELP please, Multiple errors in my formulas

Anonymous — Thu, 01 Sep 2022 15:41:48 GMT

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