Question

How to calculate expected gross profit percentage for the remaining working days in the month?

I want to forecast the gross profit percentage for the remaining working days of the current month based on current performance and trends. The calculation should consider only business days and factor in historical or projected values to estimate what the final gross profit % will be.

Answer 1

To calculate expected gross profit % for the remaining working days in Power BI:

1. Identify working days using a Date table with a [IsWorkingDay] flag.

2. Calculate actual GP% so far using filtered data up to TODAY().

3. Find average daily gross profit and revenue from elapsed working days.

4. Multiply averages by remaining working days to forecast future values.

5. Add actuals and forecasts, then compute expected GP%:

ExpectedGP% = 
DIVIDE(
    ActualGP + ForecastedGP,
    ActualRevenue + ForecastedRevenue
)