Dax function given error

[xiumi_hou]

Dear all , can someone help me look at below dax function? error: The syntax for ',' is incorrect.

Return

IF(HASONEFILTER('Cases'[name]),

IF(

BaseLineActualDate=BaseLineBaseDate,

"Not available",

IF(

SinceBaseLine_PHQ>=6 || SinceBaseLine_GAD>=4,

"Yes"),

"No")

),

"--"

)

[sturlaws · Accepted solution]

Hi @xiumi_hou ,

Could it possibly be that this part of your code:

if(
   SinceBaseLine_PHQ>=6 || SinceBaseLine_GAD>=4,
   "Yes"),
"No")

should be written like this?

if(
    SinceBaseLine_PHQ>=6 || SinceBaseLine_GAD>=4,
    "Yes",
    "No"
)

The full code would then be 

IF (
    HASONEFILTER ( 'Cases'[name] ),
    IF (
        BaseLineActualDate = BaseLineBaseDate,
        "Not available",
        IF ( SinceBaseLine_PHQ >= 6 || SinceBaseLine_GAD >= 4, "Yes", "No" )
    ),
    "--"
)

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.