Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
mirkoslav
Frequent Visitor

Cumulative column with multiple criteria

‎10-19-2023 11:02 AM

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.

Labels:
Message 1 of 6
644 Views
0
2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

‎10-21-2023 04:42 PM

Here are a couple of examples

 

power bi dax rolling 12 months at DuckDuckGo

View solution in original post

Message 2 of 6
641 Views
0
Ashish_Mathur
Super User
Super User

‎10-21-2023 05:08 PM

Hi,

PBI file attached.

Ashish_Mathur_0-1697933290553.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Running total.pbix
Message 4 of 6
630 Views
0
5 REPLIES 5
Ashish_Mathur
Super User
Super User

‎10-21-2023 05:08 PM

Hi,

PBI file attached.

Ashish_Mathur_0-1697933290553.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Running total.pbix
Message 4 of 6
631 Views
0
mirkoslav
Frequent Visitor
In response to Ashish_Mathur

‎10-22-2023 11:26 AM

Thanks a lot!

Message 5 of 6
608 Views
0
Ashish_Mathur
Super User
Super User
In response to mirkoslav

‎10-22-2023 04:56 PM

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Message 6 of 6
588 Views
0
lbendlin
Super User
Super User

‎10-21-2023 04:42 PM

Here are a couple of examples

 

power bi dax rolling 12 months at DuckDuckGo

Message 2 of 6
642 Views
0
mirkoslav
Frequent Visitor
In response to lbendlin

‎10-22-2023 11:26 AM

Thanks a lot for examples!

Message 3 of 6
608 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All