The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello,
I'm trying to manage alerts so that I can watch the inventory of the products of my company.
The purpose of this is to be notify if the stock of a product is under the minimum stock.
For example, if I have 200 coca-cola and the minimum stock is 300, I will receive an alert.
Now the problem here is that I have two columns which contains the actual stock and the minimum stock and I don't know how to make alert based on the difference of the two columns. Each product have his own minimum stock.
For example, you can see the table below :
Product Code | Actual Stock | Minimum Stock |
30000222 | 1000 | 1200 |
3002373 | 2000 | 1000 |
Solved! Go to Solution.
Hi @eric98 ,
According to your description, here is my solution.
Create a column.
Column =
IF ( 'Table'[Actual Stock] < 'Table'[Minimum Stock], 1, BLANK () )
Put the column into a card.
Set to trigger an alarm when the sum of column is greater than 0. And then you will get the notification.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @eric98 ,
According to your description, here is my solution.
Create a column.
Column =
IF ( 'Table'[Actual Stock] < 'Table'[Minimum Stock], 1, BLANK () )
Put the column into a card.
Set to trigger an alarm when the sum of column is greater than 0. And then you will get the notification.
Best Regards,
Community Support Team _ xiaosun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you create a calculation in your model that subtracts the two fields?
Hello,
Yeah I can do that !
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
36 | |
31 | |
24 | |
21 | |
20 |
User | Count |
---|---|
61 | |
59 | |
53 | |
34 | |
33 |