Forum Discussion
Custom Alerts based on Date
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.
Anonymous Thanks for the solution. So there is no chance I can show an alert based on each employee? I will have to create a report showing pool of employees who have renewal date less than 180 days.
adharia Not to my knowledge, the visuals that are supported to set up alerts on are single value.
