Forum Discussion
Custom Alerts based on Date
icobby Currently you are only able to set alerts on cards, KPIs, gauges with numeric values. So while you couldn't directly set an alert on your visual, I am thinking you could do something like.
Create a custom column or measure to calculate the number of days away from your Target date. Then, set the alert so that when it reaches below the number of days out from the target date that you want to notify them it would shoot out the alert.
Anonymous I have similar query where my dataset has for example 80 employees with their Contract renewal dates. I have also created a custom column to calculate number of days remaining for the renewal.
My question is can we set an alert when days remaining are less than 180 days for all the employees?
For Example :
Employee Contract renewal Date DateDiff XYZ 2/18/2018 180 Days ABC 1/16/2018 149 Days DEF 12/31/2017 133 Days Can I raise alert that ABC requires renewal in 149 Days, DEF requires in 133 days? If yes How?
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.
