Cumulative Budget - New Month


#1

Hi Sam,
Would you know what is causing the behavior that is jumping the cumulative Budget $$ when a new Month starts? Thanks

CumulativeBudget$:= CALCULATE([Budget Allocation],
                          FILTER(ALLSELECTED(Dim_Date),
                          Dim_Date[FullDate] <= Max(Dim_Date[FullDate])))


#2

Hi Sam, I was going to delete my post as I found what I was looking for in the “Advanced Budgeting Insights” module at around the 38 minute mark. :slight_smile:
I left it here in case anyone else stumbled across my post.
Thanks


#3

Ok great, I presume it was this technique that solved it