Hello everyone, everything good?
I have a question about something that I don't know if it is possible to do in Power BI or Power Apps.
Is it possible for Power BI to suggest values to achieve a goal?
For example:
I have 27941 products in stock that have a coverage (duration) of 23 days.
Coverage is calculated using the Number of Products in Stock X Average Daily Consumption
But assuming that the ideal coverage is 27 days, I wanted Power BI to suggest how many products I need to have to reach the Optimal Coverage of 27 days.
It is possible to do in Power BI ?
1 ACCEPTED SOLUTION
Hi @ErickReris ,
Please try below steps:
1. Calculate Average Daily Consumption: If you haven't already, you'll need to calculate the average daily consumption of your products. This can be done by dividing the total consumption over a period by the number of days in that period.
2. Create a Measure for Optimal Coverage Calculation: Use DAX to create a measure that calculates the number of products needed to reach the 27 days of coverage. The formula will look something like this:
Optimal Stock = (Average Daily Consumption * 27)
3. Calculate Additional Products Needed: To find out how many additional products are needed to reach the optimal coverage, you can create another measure:
Products Needed for Optimal Coverage = [Optimal Stock] - [Current Stock]Replace [Current Stock] with the measure or column that represents your current stock of 27,941 products.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ErickReris ,
Please try below steps:
1. Calculate Average Daily Consumption: If you haven't already, you'll need to calculate the average daily consumption of your products. This can be done by dividing the total consumption over a period by the number of days in that period.
2. Create a Measure for Optimal Coverage Calculation: Use DAX to create a measure that calculates the number of products needed to reach the 27 days of coverage. The formula will look something like this:
Optimal Stock = (Average Daily Consumption * 27)
3. Calculate Additional Products Needed: To find out how many additional products are needed to reach the optimal coverage, you can create another measure:
Products Needed for Optimal Coverage = [Optimal Stock] - [Current Stock]Replace [Current Stock] with the measure or column that represents your current stock of 27,941 products.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
