Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Sanjay Singh]

Hi,

Formula is very simple , dont know why this is giving me error.
Please check the screenshot attached.

I suppose its because of the semicolon as a seperator, but i tried it with comma also system is automatically changing the comma seperator to semicolon seperator 

Dont know why?

——————————
Sanjay Singh
Sr. Consultant
——————————

[Cekou C.]

Hi Sanjay,

You have two open parentheses after HASONEVALUE instead of one.

Kr,

——————————
Cekou C.
Accounting Supervisor & PBI Enthusiast
——————————
——————————————-

[Sanjay Singh]

I have removed one paranthesis, but still the same error.

Screenshot  attached.

——————————
Sanjay Singh
Sr. Consultant
——————————
——————————————-

[Vincent Lacomme]

Hi Sanjay,

You need to close the parenthesis of HASONEVALUE after the company name column and before the semi-colon.

For now, the parenthesis is closed at the end of the IF function.

——————————
Vincent L.
Chartered accountant – Expert-comptable
——————————
——————————————-

[Sanjay Singh]

Hi  ,

I thought True and false return relation should be part of HASONEVALUE function.

Regards
Sanjay Singh

——————————
Sanjay Singh
Sr. Consultant
——————————
——————————————-

[Vincent Lacomme]

Hi Sanjay,

HASONEVALUE only has one parameter :
https://docs.microsoft.com/en-us/dax/hasonevalue-function-dax

——————————
Vincent L.
Chartered accountant – Expert-comptable
——————————
——————————————-