Forum Discussion

JohannB's avatar
JohannB
Helper I
8 years ago
Solved

New Quick Measure

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( ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

JohannB's avatar
JohannB
Helper I
8 years ago

Hi ,

 

Please disregard the post as I have resolved it.

 

Thanks

JohannB

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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