Forum Discussion

user900's avatar
user900
Helper II
5 years ago

Using Average

I have two data sources. One includes Incident detail, the other system detail. I created a relationship between them as both have  system name and code identifiers. I have the following measures:  ...
Need Help
v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

Hi, user900 

 

Could you share some example data and draw a simple picture to show your expected visual so that i may work out with a workaround?😀

 

 

Best Regards,
Community Support Team _ Zeon Zheng

user900's avatar
user900
Helper II
5 years ago

Here is a sample of data. It shows the monthly results and the quarterly results. The quarterly results are the data points on my visual. I need the monthly to create tolerance limits which are based on historical data.

Date# of sys w. Inc not meeting SLA# of systemsmonthly % of systems w. Inc not meeting SLAquarterly
19-Apr1118  0.0085 
19-May1117  0.0085 
19-Jun4117  0.0342  0.0512
19-Jul4117  0.0342 
19-Aug6117  0.0513 
19-Sep1117  0.0085  0.0940
19-Oct1116  0.0086 
19-Nov2116  0.0172 
19-Dec2116  0.0172  0.0430
20-Jan3116  0.0259 
20-Feb0116  0.0000   
20-Mar1116  0.0086  0.0345
20-Apr0117  0.0000   
20-May1117  0.0085 
21-Jun2117  0.0171  0.0256
  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    5 years ago

    Hi, user900 

     

    I have no relevant experience with this user case and am not sure I understand your needs, do you need to create a quarterly percentage accumulation, if so then try to create the following measure

    _quarterly = CALCULATE(SUM('Table'[monthly % of systems w. Inc not meeting SLA]),DATESQTD('Table'[Date]))

    .Result:

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.