Cummulative sum of previous Months

[wisekyn77]

I am creating a matrix table with name, item ID, Item description on rows. 
Month-Year = FORMAT('Data'[Planned Date],"mmm yyyy") on columns and supply qty in values

I want a dax formula which will results in 

customer name	vendor item id	item id	desc	Jan-24	Feb-24	Mar-24
				50	10	15

Since we are in Jan 2024...It will give the sum of of all prior supply qty value that is 5+13+12+20=50.

[Fowmy · Accepted solution]

@wisekyn77 

Try this meaure:

YourMeasure =
IF (
    MONTH ( SELECTEDVALUE ( 'Data'[Planned Date] ) ) = 1,
    CALCULATE ( [Measure], 'Data'[Planned Date] <= MAX ( 'Data'[Planned Date] ) ),
    [Measure]
)