Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello,
What would it mean to write <=EARLIER within a FILTER function? For example, the argument in this is: FILTER('Data Set X','Data Set X'[Index]<=EARLIER('Data Set X'[Index]))
Would this mean to do something earlier tha a given date in the data set?
Thanks, Kendall
EARLIER returns the earlier row context.
https://www.sqlbi.com/tv/earlier-earliest-dax-guide/
The DAX expression in your screenshot appears to be a calculated column and EARLIER allows you to reference the index value in that row of the table rather than the index value inside the FILTER iterator.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 8 | |
| 7 |