Workaround for EARLIER function in DIrect Query Mode

[meetgandhi100]

Hello,

I am new to Power BI and I want to use a subsititute of EARLIER function in power BI in DIrect Query Mode for the following measure

=CALCULATE(Max(SalesTable[Sales]), FILTER(SalesTable[SalesID] = EARLIER(SalesTable[SalesID]) && SalesTable[Date] < EARLIER(SalesTable[Date]))

Any workarounds for this will be really appreciated.

Thanks

[amitchandak · Accepted solution]

@meetgandhi100 , Try a measure like

CALCULATE(Max(SalesTable[Sales]), FILTER(allselected(SalesTable), SalesTable[SalesID] = max(SalesTable[SalesID]) && SalesTable[Date] < max(SalesTable[Date]))

[meetgandhi100]

Thanks. It instantly worked.

Regarding the understanding of the concept, as Earlier function uses the current row context and compares with other rows , how is Max function replicating this behaviour in this formula?