Forum Discussion

Hombleu's avatar
Hombleu
Regular Visitor
9 years ago

Cumulative count of rows

Hi guys,   Maybe someone could help me with this issue.. I've made a connection with MYSQL db in Power BI. The db rows are based on daily base. So I've already created a countrows measure to count...
Need Help
Show and Tell
Tips and Tricks
jPinhao's avatar
jPinhao
Icon for Advocate II rankAdvocate II
9 years ago

You have to calculate the sum of the value while filtering by all dates before the current MAX - current as in the current context, which will be the the day in a bar chart with a date on the axis for instance:

 

Cummulative = CALCULATE (
                     [number]
                     FILTER ( ALL([Date]), [Date] <= MAX([Date]) )
              )