Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Quick Measures Not Being Created

I am trying to create a quick measure on a count column where it calculates a 7 day running average for said count. I fill out all of the fields in the quick measure interface and when I select OK nothing happens. 

 

I am able to create other quick measures just not this running average.

 

Below is a screenshot of the completed interface;

 

Am I doing something wrong?

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    Please create a Calendar table and the relationship.

     

     

    Then create the measure.

     

    Rolling AVG = 
CALCULATE (
    AVERAGE ( 'Table'[Count] ),
    DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Table'[Date] ), -7, DAY )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    Please provide sanitized sample data that fully covers your issue.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello,

       

      My apologies - below is a screenshot of sanitized data as well as another screenshot of how the data appears in a CSV;

       

       

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Please create a Calendar table and the relationship.

     

     

    Then create the measure.

     

    Rolling AVG = 
CALCULATE (
    AVERAGE ( 'Table'[Count] ),
    DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Table'[Date] ), -7, DAY )
)

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.