Create alerts triggered by a table column value

Power BI
1

image

Hello Experts,

I have a table visual in which contract details are displaying(Image Attached)
Client is asking to set a notification if Contract is going to expire this month. Is there any way we can achieve this in power BI.

Thanks in Advance

2

@Shoeb First create a column that will help filter those contracts that are expiring in this month.

Expiry Status Trigger = 
INT ( Alerts[End Date] <= EOMONTH ( Alerts[Start Date], 0 ) )

image
image1038×185 17.9 KB

Then in Power Automate you can get the rows that have 1 and send emails

image
image1771×2874 163 KB

image
image2115×808 101 KB

4 Likes
3

Thanks Antriksh. I will try this