Running Values with Month and Value

Hi there,

For a running total in a DAX calculated column, I find the safest way is to use ALLEXCEPT to ensure that only the columns you specify remain in the filter context for each running total.

In your case I would use:

AcumT =
CALCULATE (
    SUM ( PptoxMes[Presupuesto] );
    ALLEXCEPT ( PptoxMes; PptoxMes[Año]; PptoxMes[Projecto] );
    PptoxMes[Month_Num] <= EARLIER ( PptoxMes[Month_Num] )
)

Does that do the trick?

Owen :)

cardonasebast Look at the picture... Both of my formulas are Measures.

EDIT: You should probably add the Year field in the Matrix like this... so data is not aggregated by Month for all years