SQLDAXExcelPython
Leaderboard
Dates and reshapingMedium20 points

Rolling average

For each month of 2024, set result to the average total Amount of that month and the two before it. January and February have too few months, so they are empty.

Show solutionLifetime

Real Python running in your browser through Pyodide, with pandas available. Nothing you type is sent to a server unless you save a score.

Python
Loading editor…

Press Ctrl+Enter or Run to see the result here.