Suggesting values to reach a goal in Power BI

[ErickReris]

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 ?

[Anonymous · 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.