Forum Discussion
Anonymous
1 year agoNot applicable
cumulative sum
Hi all, I have following table year month sales 2024 january 10 2024 february 20 2024 march 30 2024 april 40 2024 may 50 2024 june 60 2024 july 70 2...
- 1 year ago
Hi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
Sales: = SUM(sales[sales])WINDOW function (DAX) - DAX | Microsoft Learn
Cumulative sales: = CALCULATE ( [Sales:], WINDOW ( 1, ABS, 0, REL, ALL ( 'calendar'[Year], 'calendar'[Month name], 'calendar'[Month number] ), ORDERBY ( 'calendar'[Month number], ASC ), , PARTITIONBY ( 'calendar'[Year] ) ) )
Anonymous
1 year agoNot applicable
thanks Jihwan_Kim thats exactly what I wanted ! youre great!