cancel
Showing results for
Search instead for
Did you mean:
Member

## SLA - Count at the end of each month

Hi all,

Consider the following as an example:

- 1 order

- 2 dates  to be considered: Date Demand - Date Resolved

- Date Demand was for example 01/01/2019

- Date Resolved was for example 01/06/2019

- This specific Order should count for the SLA of the Month 1, 2,3,4,5 and 6.

- My issue is that the order is only being caught at the last month, never in the other months.

- How to make this order to appear in the SLA count of all months??

Thanks

4 REPLIES 4
Super Contributor

## Re: SLA - Count at the end of each month

I am not sure what desired result would you want, could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Please read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Amy

Member

## Re: SLA - Count at the end of each month

Hi @v-xicai

Data Sample:

https://we.tl/t-t60iV2EZk1

In my dataset sample, highlighted in yellow are the ones that should be considered for this example.

As you can see they have Demand in one month and Presented two, three or four months later. What I am not being able to do is to make them count for my SLAs, for each month that they have been opened. For instance, one where Demand date is month 02 and presented month 04, should count for SLA on month 02, 03 and 04.

Is this clear ?

Thank you for your help.

Member

## Re: SLA - Count at the end of each month

Hi @v-xicai

I have not heard from you.  I would deeply appreciate your support on this.

Thank you.

New Contributor

## Re: SLA - Count at the end of each month

There is no data at the link provided. It may have expired.

Also, what is your current formula to determine SLA count?  You should be able to accomplish what you describe using DATESBETWEEN([List of Months],[Date Demand], [Date Resolved]) and possibly CONTAINS or something.