Not able to select column when using earlier function

[Midhun]

Hello Experts,

       I am tryiting to find the cumulative sum . when using below code i was not able to chse my column after earlier function. Please suggest

cumulative= CALCULATE(SUM(Email_Campaign[valid]),

all(Email_Campaign),Email_Campaign[Dummy_Date]<=EARLIER(

[v-stephen-msft · Accepted solution]

Hi @Midhun ,

EARLIER function is useful to calculated column. Please check whether you are using it for measure.

You can use MAX function instead of EARLIER.

cumu = CALCULATE(

sum(Email_Campaign[Valid_Email]),

FILTER(

ALL( Email_Campaign[Dummy_Date] ),

Email_Campaign[Dummy_Date] <= MAX(Email_Campaign[Dummy_Date])

)

)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Midhun]

I tried with your DAX, still facing an issue. stating that

ARLIER/EARLIEST refers to an earlier row context which doesn't exist.

cumu = CALCULATE(

sum(Email_Campaign[Valid_Email]),

FILTER(

ALL( Email_Campaign[Dummy_Date] ),

Email_Campaign[Dummy_Date] <= EARLIER(Email_Campaign[Dummy_Date])

)

)

[CNENFRNL]

DAX engine interprets this filter modifier

 CALCULATE( ... Email_Campaign[Dummy_Date] <= EARLIER( Table[someColumn] ) )

as

= CALCULATE(
    ...,
    FILTER(
        ALL( Email_Campaign[Dummy_Date] ),
        Email_Campaign[Dummy_Date] <= EARLIER( Table[someColumn] )
    )
)

and FILTER( ... ) evaluates under the filter context outside CALCULATE(); obviously, there's no row context avaible for EARLIER.