SLA Calculation based on time criteria

[Anonymous]

Hi Community, 

I really need help in finding the best approach to come to a solution to calculate the DATE DIFF days for each line/ #ref. 

Calculate average of Date Diff days between the follwoing two dates.

Table:

t_Data

Fields: 

- Date_Requested

- Date_Presented

- #ref_date

Criteria to consider:

- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider 

- If selected Date_Requested is > selected month in which #ref selected is, do not consider

- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider

Thank you guys. 

[Greg_Deckler]

Sample data and expected output would help tremendoulsy. You can simply subtract dates to get the number of days. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hello Greg, Community, 

Please have a look at the link (sample data) and also the criteria, here below: 

https://we.tl/t-RWyqc2H6s2

- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider 

- If selected Date_Requested is > selected month in which #ref selected is, do not consider

- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider

Thank you! 

Nelson

[Anonymous]

@Greg_Deckler  I do need your expertise. 

Thank you.

---

@Anonymous wrote:

Hello Greg, Community, 

Please have a look at the link (sample data) and also the criteria, here below: 

https://we.tl/t-RWyqc2H6s2

- If selected Date_Presented is < beginning of the quarter in which #ref selected is, do not consider 

- If selected Date_Requested is > selected month in which #ref selected is, do not consider

- If (Date_Requested > (end of the month - 21 days) & (Date_Presented > End of the month)) , do not consider

Thank you! 

Nelson

---