Forum Discussion

SuppiLo's avatar
SuppiLo
Frequent Visitor
4 years ago
Solved

Wrong sum with Lastdate

I have forecast table with monthly basis forecasts. Forecasts only show current month and future dates. So I need to calculate last sums from previous forecasts.

 

My measure is currently:

CALCULATE

      SUM( Forecast[Plan] ),

      LASTDATE ( Forecast[ForecastFileDate] )

)

As you can see, measure works correctly except total is wrong. It only sums from latest forecast which is August.

I tried also with:

CALCULATE(

    SUM( Forecast[Plan] ),

    FILTER(

        ALL( Forecast[ForecastFileDate] ), Forecast[ForecastFileDate] = MAX( Forecast[ForecastFileDate] )

) )

But it gives me same result as LASTDATE.

I have date table with inactive relationship with Date -> ForecastFileDate

 

Need Help
  • SuppiLo's avatar
    SuppiLo
    4 years ago

    Thanks for the reply.

    That didn't help since I didn't know how to calculate history dates.

     

    I ended with this measure:

    CALCULATE(

    SUM ( Forecast[Plan] ),

    FILTER( Forecast, Forecast[ForecastFileDate] = Forecast[Date] )

    )

    Then I summed future dates from latest file and now totals work correctly.

2 Replies