Forum Discussion

abertolett's avatar
abertolett
Frequent Visitor
8 years ago
Solved

Quick Measure for change showing 0.00%

I can't get the quick measure to work for YOY (and probably any other unit).   CTR= IF( ISFILTERED('Date'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Pow...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    abertolett

     

    Based on your measure, you are using DateAdd() function. Right?

     

    By using DateAdd() function, you can refer to the MS article and will find out that “The result table includes only dates that exist in the dates column.” It also means that this function will only return the date which is existed in the original date column.

    Please refer:

     

     

    So, in your scenario, the issue that your measure is not working maybe related to the DateAdd() function is returning blank values. Please verify this.

     

    And if you want to subtract a single year, you can try following measure:

     

    MinusOneYear =
IFERROR (
    DATE ( YEAR ( TableName[Date] ) - 1, MONTH ( TableName[Date] ), DAY ( TableName[Date] ) ),
    BLANK ()
)

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

abertolett

 

Based on your measure, you are using DateAdd() function. Right?

 

By using DateAdd() function, you can refer to the MS article and will find out that “The result table includes only dates that exist in the dates column.” It also means that this function will only return the date which is existed in the original date column.

Please refer:

 

 

So, in your scenario, the issue that your measure is not working maybe related to the DateAdd() function is returning blank values. Please verify this.

 

And if you want to subtract a single year, you can try following measure:

 

MinusOneYear =
IFERROR (
    DATE ( YEAR ( TableName[Date] ) - 1, MONTH ( TableName[Date] ), DAY ( TableName[Date] ) ),
    BLANK ()
)

 

Thanks,
Xi Jin.