Forum Discussion

meetgandhi100's avatar
meetgandhi100
Frequent Visitor
6 years ago
Solved

Workaround for EARLIER function in DIrect Query Mode

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

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    meetgandhi100 , Try a measure like 

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    meetgandhi100 , Try a measure like 

    CALCULATE(Max(SalesTable[Sales]), FILTER(allselected(SalesTable), SalesTable[SalesID] = max(SalesTable[SalesID]) && SalesTable[Date] < max(SalesTable[Date]))
    • meetgandhi100's avatar
      meetgandhi100
      Frequent Visitor
      6 years ago

      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?