Distribute values between two dates

[Anders_G]

I have these forecast amounts that I want to distribute evenly in the upcoming quarters (not including the quarter of the start date).

I have been able to do an even distribution between the start and end dates by creating new columns that adds all the dates between the start and end dates and then based on the number of days between the dates calculates an amount per day.

So far everything works. But, I have been asked to not include the quarter in which the start date falls. So the calculation should not start from 2022-01-01, but 2022-04-01. (Q1= Jan-Mar, Q2=Apr-Jun, Q3=Jul-Sep, Q4=Oct-Dec)

So the same amount (150,000). But, evenly divided over Q2-Q4. How could I calculate this?

 

[v-kkf-msft · Accepted solution]

Hi @Anders_G ,

Please add the new column.

Column =
DIVIDE (
    SUM ( 'Table'[Forecast Amount] ),
    COUNTROWS (
        FILTER (
            Dates,
            Dates[QUARTER] > QUARTER ( MAX ( 'Table'[Start date] ) )
                && Dates[Date] <= MAX ( 'Table'[End date] )
        )
    )
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.