Running totals from the beginning of time (DAX – Power Pivot, Power BI)

In DAX you can very simply calculate measure from the beginning of year, quater, month…

But sometimes you have to calculate from the beginning – regardless years, months etc.

So how to start?

Having a fact table and time dimension (you should have time dimension), the formula can be like this:

  • Revenue from big bang =
        CALCULATE(sum(revenue[Revenue]),
        KEEPFILTERS(date_dim[Date]<=MAX(date_dim[Date])))

The syntax is clear. Calculate merges the calculated value with filter. Filter limits values only for same or smaller compared to evaluated period.