Forum Discussion
SLA Calculation based on time criteria
Community ChampionSample 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