Why EARLIER for row context in Power BI? - Purpose & Use Cases

The Big Idea

Discover how a single function can save you hours of tedious manual work and errors!

The Scenario

Imagine you have a sales table and you want to calculate a running total or compare each row's value to previous rows manually in Excel or by writing complex formulas.

You try to do this by copying formulas down or using multiple helper columns, but it quickly becomes confusing and hard to maintain.

The Problem

Manual methods are slow because you must update formulas for every new row.

They are error-prone since copying formulas can break references or produce wrong results.

Also, manual approaches don't scale well when data grows or changes frequently.

The Solution

The EARLIER function in Power BI lets you easily refer back to an earlier row's value within the same calculation.

This means you can write a single, clear formula that works for all rows, automatically handling the row context without extra columns or manual copying.

Before vs After

✗ Before

For each row, manually sum previous rows' sales using helper columns and copy formulas down.

✓ After

RunningTotal = CALCULATE(SUM(Sales[Amount]), FILTER(Sales, Sales[Date] <= EARLIER(Sales[Date])))

What It Enables

It enables dynamic, row-by-row calculations that automatically consider previous rows without manual effort.

Real Life Example

A sales manager can quickly create a running total of daily sales to see trends over time without building complex spreadsheets.

Key Takeaways

Manual row-by-row calculations are slow and error-prone.

EARLIER lets you refer to previous rows easily within one formula.

This simplifies and speeds up creating running totals and comparisons.