Power BI : why EARLIER() does not recognize date column?

Question

I am using the following Power BI Formula:

prices = SUM(Testing[price])

comulativetest = CALCULATE([prices],FILTER(Testing,EARLIER(Testing[Date])>=Testing[Date]))

I am facing an error

 

Answer 1

Use one-to-many join and use measure like this:

comulativetest :=
CALCULATE (
    [prices],
    FILTER (
        ALL ( Dates ),
        Dates[Date] <= MAX ( Dates[Date] )
    )
)

If you want to learn more about Power BI, then read the Power BI Tutorial.

Also, enroll in Power BI online Training to become proficient in this BI tool.