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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cocrodile
Helper I
Helper I

Comulative sum Within Categories

Hi I have this table and I wish I could implement the cumulative function on dax.

------------------------------------------------------------------

-The CAT field is the field with reference to the category

-The WEEK field is the field referring to the week

-The Ticket field is the field with reference to the ticket number

-The CUMULATIVE field is the value I would like to get out in DAX and refers to the cumulative

-------------------------------------------------------------------------

Cocrodile_0-1647593823814.png

 

-------------------------------------------------------------------

 

 

I would need a dax formula to calculate the cumulative.
In this case I only reported week 10 but it should calculate the cumulative sum for each week in relation to the category (CAT field).
Each week I have different categories
A thousand thanks

 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Cocrodile , based on what I got

sumx(filter(allselected(Table), Table[Cat] = max(Table[Cat])  && Table[Week] <= max(Table[week]) ), [ticket])

I have created the measure but testing it but it doesn't make the cumulative sum it brings me only the values

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.