Calculated Column Nested If issue

[HS_PDS]

Im trying to get this Nested IF statement to work:

Goal% = [Goal Count] / IF([Period] = "Current Month",1,IF([Period] = "Trailing 3" , 3,IF([Period] = "YTD" , 12,"")))

I keep getting the following error:

"Function 'PlaceHolder' is not allowed as part of calculated column DAX expressons on DirectQuery Model"

I basically want to sum the numerator and divide by the period (1,3,12)

any direction is greatly appreciated, thanks in advance

[edhans · Accepted solution]

I'd need to see data to really see what is going on, but in your last IF statement, if it isn't "Current Month", "Trailing 3", or "YTD" it will try to divide by "", which cannot happen.

Try this to clean that up:

Goal% =
DIVIDE (
    [Goal Count],
    IF (
        [Period] = "Current Month",
        1,
        IF ( [Period] = "Trailing 3", 3, 
		IF ( [Period] = "YTD", 12, 0 )
	)
    ),
    0
)

That will provide a safe divide where dividing by zero will return zero instead of an error. THat might clean that Function Placeholder error