Forum Discussion
need a daily Alert
hi all, there are really less options for alerts in power bi service! i have created following dax formula in PBI Desktop: Alert = IF([price] >= [price_plan] * 0.25, 1, 0) and put it in ...
Hello. Yes i could configure it. Every 24 Hours because we update data once a day. But in the configuration it is written that Alters are only sent if your data changes. And IF([price] >= [price_plan] * 0.25, 1, 0) is every day 1 as long as [price] >= [price_plan] * 0.25. Hence no alerts.
Oh. I see now. You may be able to cheat that changing the 1 from the TRUE response of the if with something like:
RAND() + 1Sum a random value from 0 to 1 + 1. Then you will always get a different value like 1.23 or 1.54
That way the value will change and be higher than 0.
I hope that helps,