Forum Discussion
SLA Calculation based on multiple criteria
Hi v-xicai ,
You did get to the solution, can you help me construct the function with all the criterias?
Sample of the real dates and refs :
Thank you so much!
Nelson
Super UserAnonymous it is still very confusing what you want and how you worded your question. You are sharing sample data but not expected output, can you put some notes in excel file based on sample data what actually you are looking for.
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
parry2k Thank you for reaching out and try to help me.
Sample of the real dates and refs :
based on this dataset, the criteria to achieve this SLA metric is:
- If selected Date_Presented is < beginning of the quarter which #ref selected is, do not consider (don't show rows)
- If selected Date_Requested is > selected month in which #ref selected is, do not consider
- If (Date_Requested > (end of the month of #selected month- 21 days) & (Date_Presented > End of the month of #selected month) , do not consider