Forum Discussion
Custom Alerts based on Date
Is there a way to set custom alerts on visuals based on Dates? The report I'm working on is designed to show a List of Items, Owners of those Items and Target Dates for tasks. If I were able to set a...
adharia A way I see doing this is creating a measure that will return only those values under 180, then choosing the Max of that value. Something like: Measure = CALCULATE(MAX('Table1'[DateDiff]), FILTER('Table1','Table1'[DateDiff]< 180))
Now this won't go employee by employee, but in my mind that wouldn't matter because I'm looking at all employees, so this just returns the closest employee to 180. Then a report can show me the specifics of which employees fall into that bucket and how many days remaining they have.
Brilliant, this worked for me.