Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Reddyp
Helper I
Helper I

Group sum/cumulative total/Running total

Calculate group sum whn you have 2 or more categories

Final output: Group sum is calculated based on categories 

Reddyp_0-1639465741830.jpeg


Process:
1. Upload data > transform data > Add column > Index Column > From 1 
you will see index colum in your data, save and close 
2. Load data into "Data" colum in power BI, 
From "Fileds" > Add "New Column > use Dax code mentioned below 

Group sum =
SUMX (FILTER (
'ABC - LW6',
EARLIER ( 'ABC - LW6'[Category] ) = 'ABC - LW6'[Category]
&& EARLIER ( 'ABC - LW6'[Index] ) >= 'ABC - LW6'[Index]), 'ABC - LW6'[total sales1])

Result: 
Reddyp_0-1639466275534.png

 


 

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @Reddyp 

 

Thank you for sharing your solution and experience with the community!

 

Best Regards,
Community Support Team _ Jing

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors