Update the Base Values to the Newer Values after a trigger point

[Anonymous]

Hi,

I am a new user of Power BI and Power Automate. I am currently working on a project where:
1. I have 2 tables, 1st table has machine code and 2nd table has it's meter reading. The meter readings are already there for each machine and we are not starting from 0.

2. This meter reading is done every day and it is always greater or equal to the previous reading.

3. I want to build a power automate system where a person gets an email every time the machine meter reading crosses 500 points more than the base count.

4. I want that the base value should change to the value where the email was sent for maintenance so that the next 500points are calculated from the newer value.

5. I don't have a base value table

Please suggest me how to go about this. Note that the data is saved in Microsoft SQL server management.

[Idrissshatila]

Hello @Anonymous ,

So what you could do is compare yesterdays value with current value and get the difference, then you set the alarm on this difference value which if this difference is greater than 500 send an alarm else it wont.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Anonymous]

Hi,

I tried doing this but for some reason I am not able to see the Alerts option on my end. I did check all the limitations on microsoft site.

I get the same option in cards as well.
Any suggestions apart from checking with IT?

Thanks.

[Anonymous]

Okay, I will try this thing and let you know! Thank you 🙂 

[Idrissshatila]

Hello @Anonymous ,

instead of power automate you could use alerts in Power Bi where you set a threshold and if it was crossed an alert would notify a certain user by sending an email.

check it out here https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Anonymous]

Thanks for the prompt reply.
Oh that's great to know that there is such an option. Do you think I can do this too - Update the base table to the newest transaction value everytime an email is sent? 

I have tried creating a base table by taking the recent values. What I want is  everytime a new record is added to the main table it should compare it with the base table and if it more than 500 send an email. Sorry if my questions are silly, I am super new and internet doesn't seem to have a lot of info on this issue.

Thanks.