running sum based on dates

Hi Expert,

I wanted to add running column based on running sum as third column in power BI based on date

amitchandak
Super User
4 years ago
Anonymous , a new column

sumx(filter(Table, [Date] < earlier([Date]) ), [sales Count])

a new measure =

sumx(filter(allselected(Table), Table[Date] < max(Table[Date]) ), Table[sales Count])
- Anonymous
  Not applicable
  4 years ago
  Hi Expert,
  but the saledate is coming from Datetable and salecount from sales table how we can differentiate in calculation
Anonymous
Not applicable
4 years ago
Hi Expert,
but the saledate is coming from Datetable and salecount from sales table how we can differentiate in calculation
v-jingzhang
Community Support
4 years ago
Hi Anonymous

You need to create a relationship between Date table and Sales table on date column (one-to-many, single direction). Then create the following measure

Cumulative Total = CALCULATE ( SUM ( 'Sales'[SalesCount] ), FILTER ( ALL ( 'Calendar Table' ), 'Calendar Table'[Date] <= MAX ( 'Calendar Table'[Date] ) ) )

Here are some blogs for your reference:

Power BI: Calculating Cumulative Totals for Time Periods

Computing running totals in DAX - SQLBI

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Forum Discussion