Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi Team
thank you in advance for your support 🙂
we have a table of excel with this info
-product id -time period -purchase$ -forecast depletion$ -stock on hand$ -projected stock$
I need know the product id is a
slow mover forecast ( > 6 month forecast )
no mover 6 month (movemet is 0 or movement depletion stock is below 10% of the final stock during period)**
no mover 1 year ""
no mover 2 year ""
** take in account is posible it have a several purchases in the middle of periods in the same product,
in this case we need choose the last date of purchase as reference )
or entry in stock product in last 5 month in this case product became in new introduction
kind regards
ricard
Hi, @rdiazd73
Could you show us some sample data and expected result with OneDrive for business? Do mask sensitive data before uploading. Thanks.
Best Regards
Allan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |