Cumulative column with multiple criteria

[mirkoslav]

Hi Power BI community,

I have strugle with creating cumulative column, when making measureI managed. Can somebody help?

I have table like one below and I want to make cumulative column which will show sales in last 12 monhts filtered by country and product. Example is simple. Products can be different .

Date	Country	Product	Sales	Cumulative column 12 months
31.1.2022	Germany	Apple	10	10
28.2.2022	Germany	Apple	20	30
31.3.2022	Germany	Apple	50	80
30.4.2022	Germany	Apple	30	110
31.5.2022	Germany	Apple	20	130
30.6.2022	Germany	Apple	10	140
31.7.2022	Germany	Apple	50	190
31.8.2022	Germany	Apple	15	205
30.9.2022	Germany	Apple	25	230
31.10.2022	Germany	Apple	30	260
30.11.2022	Germany	Apple	40	300
31.12.2022	Germany	Apple	15	315
31.1.2023	Germany	Apple	32	337
31.1.2022	France	Apple	98	98
28.2.2022	France	Apple	20	118
31.3.2022	France	Apple	30	148
30.4.2022	France	Apple	10	158
31.5.2022	France	Apple	40	198
30.6.2022	France	Apple	50	248
31.7.2022	France	Apple	34	282
31.8.2022	France	Apple	55	337
30.9.2022	France	Apple	35	372
31.10.2022	France	Apple	32	404
30.11.2022	France	Apple	78	482
31.12.2022	France	Apple	54	536
31.1.2023	France	Apple	45	483

I couldn't find similar example on forum.

Thanks in advance.

[lbendlin · Accepted solution]

Here are a couple of examples

power bi dax rolling 12 months at DuckDuckGo

[Ashish_Mathur · Accepted solution]

Hi,

PBI file attached.

[mirkoslav]

Thanks a lot!

[Ashish_Mathur]

You are welcome.

[lbendlin · Accepted solution]

Here are a couple of examples

power bi dax rolling 12 months at DuckDuckGo

[mirkoslav]

Thanks a lot for examples!