Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Actuals vs Average + Chart Date Filtering

Hi all,   Having an issue with filtering a chart that contains a measure which subtracts a 3-month average of Actuals pre Project start date (Dec19) from current Actuals. Per screenshot below, w...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Sorry for the late reply,try to use "dateadd" instead of "dateinperiod":

    AVG.PRE-REV =
CALCULATE(
[MRR(no RFS)]
, DATEADD( 'CALENDAR'[Date] , -3 , MONTH )&&
MAX( PROJECT_LOOKUP[RFS.DATE] )<=DATE(2020,11,31)))
/3

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-kelly-msft thanks for the response.

 

I still have the issue that the months are still visible outside of the range I want to see (i.e. all of 2019 and 2021).

 

Also, in my actual data model I have other tables linked to the 'CALENDAR' table and 'PROJECT_LOOKUP' tables so that I receive this error when I try to change that relationship to 'Both':