Forum Discussion
Microsoft EmployeeRecord level PowerBI Alerts
Community, I have researched several post to what I am trying to do put I can't come to a workable solution because I am new to PowerBI. Can someone point me in the right direction?
I am trying to take the per store records below and alert through email when the "Growth" of a store moves a precentage point in the postive or negative direction from the month. If store 1000 moves from -2.9 to -1.9 in the next data refresh I want to alert on that 1% change. The solution it releated to tracking stocks, you made want to be alerted on a 10% move of a stock in a day, week, month or since you bought it so you call sell.
Formulas
Growth = CY LTM - PY LTM/PY LYM x 100
Diff to Mkt = Store CY LTM - Market CY LTM/Market CY LTM x 100
CY LTM = Months Revenue/12
1 Reply
- AllisonKennedy
Community Champion
When you say 'alerts' are you actually wanting the email from dashboard alerts?
You will likely need to define an explicit measure, and need to define a period (more specific than 'since last refresh'). So try for example change since last week or last month. You can find lots of samples for WoW or MoM % change in DAX. Then set this in a card visual, pin to dashboard, and set an alert on it.
Does that help and did I understand what you wanted?
