topic Re: 3 months rolling sum in DAX Commands and Tips

3 months rolling sum

jimpatel — Mon, 01 Jul 2024 12:37:45 GMT

Hi,

Thanks for looking at my post. I am looking for some DAX formula for 3 months rolling sum of calculated column please? Any idea please?

Thanks a lot

Re: 3 months rolling sum

lbendlin — Mon, 01 Jul 2024 15:33:06 GMT

Sounds straightforward (apart from the data duplication - why a calculated column?). What have you tried and where are you stuck?

Re: 3 months rolling sum

jimpatel — Mon, 01 Jul 2024 15:54:30 GMT

Thanks for your reply. I got stuck with "3 months rolling Sum" section. The answer shown is expected.

Thanks a lot

Re: 3 months rolling sum

lbendlin — Mon, 01 Jul 2024 16:13:31 GMT

Please provide sample data that fully covers your issue. Show more than three months of data. Ideally in usable format, not as a screenshot.
Please show the expected outcome based on the sample data you provided.

Re: 3 months rolling sum

Anonymous — Mon, 08 Jul 2024 03:21:08 GMT

Hi lbendlin ,Thanks for your quick reply, I will add more.

Hi jimpatel ,

The Table data is shown below:

Use the following DAX expression to create columns.

Column = YEAR('Table'[Date]) * 100 + MONTH('Table'[Date])

Rank = RANKX('Table',[Column],,ASC,Dense)

3 months rolling sum = VAR _rank = [Rank] VAR _table = SUMMARIZE('Table',[Rank],[Calculated Column]) RETURN SUMX(FILTER(_table,[Rank] <= _rank && [Rank] >= _rank - 2),[Calculated Column])

Final output

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: 3 months rolling sum

jimpatel — Tue, 16 Jul 2024 09:29:59 GMT

Thanks a lot. It works perfect.