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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gtamir
Post Patron
Post Patron

CumulativeTotal by Index

‎07-19-2018 07:20 AM

Hi

I am trying to create a cumulative column from the Total and Index column in the table SalesByCustomer.

What is wrong in my formula?

Thanks Giora

ScreenHunter_073.jpg

Labels:
Message 1 of 5
465 Views
0
1 ACCEPTED SOLUTION
gtamir
Post Patron
Post Patron
In response to popov

‎07-19-2018 10:30 AM

Thanks but it has a problem.

 

ScreenHunter_074.jpg

View solution in original post

Message 3 of 5
472 Views
0
4 REPLIES 4
popov
Resolver III
Resolver III

‎07-19-2018 07:43 AM

Hello, @gtamir
Correct formula below

Cumulative Total =
SUMX (
    FILTER (
        SalesByCustomer,
        SalesByCustomer[Index] <= EARLIER ( SalesByCustomer[Index] )
    ),
    SalesByCustomer[Total]
)

Message 2 of 5
456 Views
0
gtamir
Post Patron
Post Patron
In response to popov

‎07-19-2018 10:30 AM

Thanks but it has a problem.

 

ScreenHunter_074.jpg

Message 3 of 5
473 Views
0
popov
Resolver III
Resolver III
In response to gtamir

‎07-19-2018 10:35 PM
Do you create calculated column?
Message 4 of 5
447 Views
0
gtamir
Post Patron
Post Patron
In response to popov

‎07-19-2018 11:34 PM

Ah ha. Now I fixed it. Thanks

Message 5 of 5
443 Views
0

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

View All