I am stuck with in a scenario , wherein i need to identify the list of users who have breached a particular criteria each month based on Start date and end date column.
Example if a person A has again breached a particular SLA , he needs to be highlighted which gives a impression to the end user that he had breached the SLA in previous month as well.I have created a calculated column Abuser list based on which i need to identify the user
I have attached the PBIX with Sample data.
Also i was trying to calculate the sum of particular value using the formula
Total OG Calls_Test = CALCULATE(SUM(Sheet1[TOT_OUTGOING_CALLS]),
FILTER(VALUES(sheet1[MI_FROM_DATE]),Sheet1[MI_FROM_DATE] <= Max(‘Invoked Function’[Date])),
FILTER(VALUES(Sheet1[MI_TO_DATE]),Sheet1[MI_TO_DATE] >= Min(‘Invoked Function’[Date])))
But some how when i select a particular calendar month it gives me wrong result.The number for each day is very high not sure whether is getting rolled up
sample.pbix (421.8 KB)
Kindly request you to help please.