Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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.

General Comment

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      Okay, I will try this thing and let you know! Thank you ๐Ÿ™‚ 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.