Forum Discussion
Automated emails from table values
Anonymous If you pin your card with # invoices at 0 to a dashboard you can set up an alert following this doc Set data alerts in the Power BI service - Power BI | Microsoft Docs.
For your ask on the daily change alert, you can create a measure that populates a card that will only be the daily change and pin that to a dashboard and have the alert set up. For example:
Today Change Since Yesterday 0 Invoices =
VAR yesterdayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date]
= TODAY () - 1
)
VAR todayinv =
CALCULATE (
COUNTROWS ( 'Invoices' ),
FILTER ( 'Invoices', [Days Until Due] <= 0 ),
'Date'[Date] = TODAY ()
)
VAR diff = todayinv - yesterdayinv
RETURN
diffDataZoe i have modified the measure you created as below
Automated Email Alert =VAR yesterdayinv =CALCULATE (DISTINCTCOUNT('Filtered invoice Reminder Table'[Study Title]),FILTER ( 'Filtered invoice Reminder Table', [Days Till Next Invoice 2] = -2 ),'Filtered invoice Reminder Table'[Next Invoice Date]= TODAY ())VAR todayinv =CALCULATE (DISTINCTCOUNT('Filtered invoice Reminder Table'[Study Title]),FILTER ( 'Filtered invoice Reminder Table', [Days Till Next Invoice 2] = -2 ),'Filtered invoice Reminder Table'[Next Invoice Date] = TODAY () +2)VAR diff = todayinv - yesterdayinvRETURNdiffi now records correctly and when added to flow as an alert works as intenededthank you again for your helpit is very much appreciated 😀
Anonymous Once you pin the card to a dashboard, you can click the "..." on the tile and set up the alert. No flow needed :).
You can also set them up with a flow too, if you don't want to create a dashboard.
DataZoe i have modified the measure you created as below
Anonymous that is awesome to hear!