Forum Discussion

mirkoslav's avatar
mirkoslav
Frequent Visitor
2 years ago
Solved

Cumulative column with multiple criteria

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 .

DateCountryProduct SalesCumulative column 12 months
31.1.2022GermanyApple1010
28.2.2022GermanyApple2030
31.3.2022GermanyApple5080
30.4.2022GermanyApple30110
31.5.2022GermanyApple20130
30.6.2022GermanyApple10140
31.7.2022GermanyApple50190
31.8.2022GermanyApple15205
30.9.2022GermanyApple25230
31.10.2022GermanyApple30260
30.11.2022GermanyApple40300
31.12.2022GermanyApple15315
31.1.2023GermanyApple32337
31.1.2022FranceApple9898
28.2.2022FranceApple20118
31.3.2022FranceApple30148
30.4.2022FranceApple10158
31.5.2022FranceApple40198
30.6.2022FranceApple50248
31.7.2022FranceApple34282
31.8.2022FranceApple55337
30.9.2022FranceApple35372
31.10.2022FranceApple32404
30.11.2022FranceApple78482
31.12.2022FranceApple54536
31.1.2023FranceApple45483

 

I couldn't find similar example on forum.

Thanks in advance.

Need Help

5 Replies