Multiple condition & Power Formula in Power BI issue

Hi JIN23 ,

Thanks for reaching out to the community. Please try:

Forecast Stock Gross = 
IF(
    Dim_WK[week_full_no] >= Dim_WK[Launching week],
    CALCULATE(SUM([Bought Gross]), FILTER(Dim_WK, Dim_WK[week_full_no] >= Dim_WK[Launching week])),
    IF(
        Dim_WK[week_full_no] > Dim_WK[Closing week],
        CALCULATE(POWER([Bought Gross] * (1 - [Speed Plan]), [Closing week diff]), FILTER(Dim_WK, Dim_WK[week_full_no] > Dim_WK[Closing week])),
        IF(
            Dim_WK[week_full_no] = Dim_WK[Closing week],
            CALCULATE(POWER([Stock gross] * (1 - [Speed Plan]), [Closing week diff]), FILTER(Dim_WK, Dim_WK[week_full_no] = Dim_WK[Closing week])),
            BLANK()
        )
    )
)

This formula uses nested IF statements to handle the different conditions and SUM to aggregate the Bought Gross values. It also ensures that the POWER function is used correctly.

Give this a try and see if it resolves the issue. If you still encounter problems, please let me know!

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.