Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have got sales values. I want to create a column, which contains the cumulative/running sum of the last 48 sales values. Any help in this regard would be really appreciated.
Regards
Yasir
Solved! Go to Solution.
Hi,
You should add an index column to the table if you don't already have it. Just a click in Power Query.
Then something like this:
NewColumn =
VAR CurrentIndex = 'Table'[Index]
RETURN
CALCULATE (
SUM ( 'Table'[ColumnToSum] ),
FILTER (
ALL ( 'Table' ),
'Table'[Index] > CurrentIndex - 48
&& Table[Index] <= CurrentIndex
)
)
Hi,
You should add an index column to the table if you don't already have it. Just a click in Power Query.
Then something like this:
NewColumn =
VAR CurrentIndex = 'Table'[Index]
RETURN
CALCULATE (
SUM ( 'Table'[ColumnToSum] ),
FILTER (
ALL ( 'Table' ),
'Table'[Index] > CurrentIndex - 48
&& Table[Index] <= CurrentIndex
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |