rolling alerts in BI report for the table

[Analyst001]

I am creating a report with the simple values in the table and need to create a rolling alert for them. Please suggest to me how do we create rolling alerts on the PBI desktop.

[v-angzheng-msft · Accepted solution]

Hi, @Analyst001 

You can create a measure to determine if the dates in the table meet your conditions.

For example, the date is displayed open for the current month, and the previous date is closed.
To create a measure like below:

Measure =
VAR _selected_month =
    MONTH ( MAX ( 'Table'[Date] ) )
VAR _current_month =
    MONTH ( TODAY () )
RETURN
    IF ( _selected_month = _current_month, "Open", "Closed" )

Result:

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@Analyst001 

I did not quite understand the question when you mentioned the "Rolling Alerts in Desktop". However, Power BI allows you to set alerts in the Power BI service from selected dashboard visuals. Please refer to the following article on how to use them up.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

[Analyst001]

Thank you Fowmy,

My requirement is like....the ticket is open in one month and closed in next month and I have to show them in rolling alerts like open and close in the graph. I hope I explained well. 

[Fowmy]

@Analyst001 

I suggest you post some sample data and the expected results.