Forum Discussion

EnderWiggin's avatar
EnderWiggin
Icon for Helper I rankHelper I
5 years ago

Running Total calculation based on criteria

Hi All, I would like to ask your help to solve to following running total calculation problem as it is clearly above of my DAX knowledge. Please, see this PBI file link for more details: RunningTot...
Need Help DAX measure
Runnig Total
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Your data model is missing a Calendar/Dates table.  If you add that then you can improve your measures to gracefully handle situations where there is no data for a particular material and month.

  • EnderWiggin's avatar
    EnderWiggin
    Icon for Helper I rankHelper I
    5 years ago

    Hi lbendlin,

    sorry for the late response. Yes, you are right, meanwhile I created a dynamic calnedar table based on the min/max year/month values of StockInputOutput (I added a date field to this table whic is the first day of the month e.g 202107 -> 2021.07.01) and set the connection betwwen the two tables based on dates. So it was missing to show running in the matrix continously. 

    Thank you for your feedback!