Tricky - measure to add columns in matrix table

[Anonymous]

Hi Experts

See sample file with matrix table. . I want to create a new matrix which has Year_month in the Row and Month in the column as the previous table. BUT the values in Month 0 remain

New Month 1 = Month 0 +Month 1 

New Month 2 = Month 0 +Month 1 +Month 2 

and so on...

https://www.dropbox.com/s/0bdlo5sjw9soi7w/FADSampleData%20%282%29.pbix?dl=0 

[Fowmy · Accepted solution]

@Anonymous 

You can add a measure as follows:

Measure = 
var __m =  MAX(Llo_FAD_Data[Month]) return
CALCULATE(
    SUM(Llo_FAD_Data[Result]),
    ALLSELECTED( Llo_FAD_Data[Month] ),
    Llo_FAD_Data[Month] <= __m
)