Forum Discussion
SLA Calculation based on time criteria
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.
3 Replies
- Greg_Deckler
Community Champion
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
Hello Greg, Community,
Please have a look at the link (sample data) and also the criteria, here below:
- 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
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:
- 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
