New Quick Measure

[JohannB]

Hi, Can someone please assist, I keep on getting the error message below when using the quick measure year-on-year and the error message is that "the syntax for year is incorrect:

Count YoY% =
IF(
ISFILTERED('Query2'[ApplicationDate]).
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.").
VAR __PREV_YEAR =
CALCULATE(
SUM('Query2'[Count]).
DATEADD('Query2'[ApplicationDate].[Date]. -1. YEAR)
)
RETURN
DIVIDE(SUM('Query2'[Count]) - __PREV_YEAR. __PREV_YEAR)
)

the result is as follow:

The data used is as follow:

Thank you

[JohannB]

Hi ,

Please disregard the post as I have resolved it.

Thanks

JohannB

[Anonymous · Accepted solution]

Hi @JohannB,

I'm not so sure why you use dot characters as the separator of dax functions.

I modify your formula and use comma to replace the wrong separators, maybe you can try to use below formula.

Count YoY% =
IF (
    ISFILTERED ( 'Query2'[ApplicationDate] ),
    ERROR ( "Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column." ),
    VAR __PREV_YEAR =
        CALCULATE (
            SUM ( 'Query2'[Count] ),
            DATEADD ( 'Query2'[ApplicationDate].[Date], -1, YEAR )
        )
    RETURN
        DIVIDE ( SUM ( 'Query2'[Count] ) - __PREV_YEAR, __PREV_YEAR )
)

If above not help, please share the pbix file for test.

Regards,

Xiaoxin Sheng