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(
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

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

2 Replies

  • 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