Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Send alerts to users based on status changes

Hello Power Users, I'm trying to send alerts when there is a data changes. For example if the status column changes from "Start"  to "In Progress" then i want to send an alert via email with the d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

Basically the entire data in the table will delete at night and will get updated with new data

If you want to compare data last day with data today, I think you need to keep last day data in your table. If you delete previous data at night, Power BI couldn't find your data. And we need a [Date] column to determind when is the data from.

Sample:

Measure:

ABC Change =
VAR _YEASTERDAY_STATUS =
    CALCULATE (
        MAX ( 'Table'[Status] ),
        FILTER ( 'Table', 'Table'[Name] = "ABC" && 'Table'[Date] = TODAY () - 1 )
    )
VAR _Today_STATUS =
    CALCULATE (
        MAX ( 'Table'[Status] ),
        FILTER ( 'Table', 'Table'[Name] = "ABC" && 'Table'[Date] = TODAY () )
    )
RETURN
    IF ( _Today_STATUS = "In progess" && _YEASTERDAY_STATUS = "Start", 1, 0 )

Then add alert in Power BI Service.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank for the response. It's not only for "ABC". It should be for Every name. When the status changes from Start to In Progress then have to send alerts.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    I suggest you to try this measure.

    Measure = 
VAR _SUMMAIZRE =
    SUMMARIZE (
        ALL ( 'Table' ),
        'Table'[ID],
        "Combine",
            VAR _YEASTERDAY_STATUS =
                CALCULATE (
                    MAX ( 'Table'[Status] ),
                    FILTER ( ALLEXCEPT ( 'Table', 'Table'[ID] ), 'Table'[Date] = TODAY () - 1 )
                )
            VAR _Today_STATUS =
                CALCULATE (
                    MAX ( 'Table'[Status] ),
                    FILTER ( ALLEXCEPT ( 'Table', 'Table'[ID] ), 'Table'[Date] = TODAY () )
                )
            VAR _COMBINE =
                COMBINEVALUES ( "-", _YEASTERDAY_STATUS, _Today_STATUS )
            RETURN
                IF ( _COMBINE = "Start-In Progress", 1, 0 )
    )
RETURN
SUMX(_SUMMAIZRE,[Combine])

    Then manager your alert to send emails when value is greater than 0.

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.