Forum Discussion
SLA Calculation based on multiple criteria
Anonymous 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
Anonymous you alredy shared that file, thanks for sharing again Based on your data in the sheet, can you put another sheet with expected output.
parry2k I have commented in the sheet, hope it clarifies. Once again, thank you so much!
Data :
Anonymous what you mean by "selected month" in following
2) do not consider this row (for eg: FP#00119) for the selected month if:
- Date_Presented is > end of the selected month
- Date_Demande is > end of the selected month - 21 Days
- Date_Presented is < Beginning of the Quarter that the selected month belongs to.Hi parry2k
Basically, this will be placed in the main Dashboard, and the main filter there will be "Date", therefore what I would like to achieve is basically if a manager selects "March", the SLA 01 will have those criteria in consideration based on the selected month. Please do let me know if this make any sense ?
Thank you for your help!
Nelson