ACCUMULATED MIN

[jhodasoft]

Good afternoon!, The idea is to get the accumulated from the Projection column and I can't get it. Can someone help me?
Image 01

Image 02

Image 03

[tamerj1]

@jhodasoft 

You cannot calculate a variable inside CALCULATE. You need not to use a variable in this case. The MIN aggregation has to be referenced directly inside the CALCULATE function. 

[FreemanZ]

hi @jhodasoft 

try like:

Measure =

SUMX(

    FILTER(

        ALL(TableName),

        MONTH(TableName[Date])<=MAX(MONTH(TableName[Date]))

     ),

    [Projection]

)

[jhodasoft]

Thanks for answering @FreemanZ , but I still can't get it.

[FreemanZ]

hi @jhodasoft 

post some sample data and let us see. 

[jhodasoft]

Hi @FreemanZ , thanks for answering, I will copy part of the data below.