Forum Discussion

momedina's avatar
momedina
Frequent Visitor
8 years ago

Power BI

I have a very simple table with two columns. Date, and Daily Events. The data comes a Big Data DB. The events are already aggregated per day but I want to run a cummulative total. The DAX CALCULATE f...
d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
6 years ago

Since NumberOfDailyEvents is a column you will just need to provide an aggregate function like SUM() to tell the tabular engine how to aggregate the values.

 

eg.

 

CALCULATE (
    SUM([NumberOfDailyEvents]),
    FILTER (
        ALL ( 'Date'[Date] ),
        'Date'[Date] <= MAX ( 'Date'[Date] )
    )
)