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

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.