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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

How to get accumulate by several measurement?

Hi there, 

I am looking for the accumualted value for below two measurement column, excel is what i am expecting. I have used below formula but not working since it not allow me to do sum(total accepted value)

jiangmingming_2-1680279836274.png

 

jiangmingming_0-1680279711209.png

jiangmingming_1-1680279782045.png

 

 

4 REPLIES 4
olgad
Super User
Super User

Hi,

Cumulative Total =

CALCULATE(

    [Total Accepted Value]

    FILTER(

        ALL('Opp and primary quote new'),

        'Opp and primary quote new' [Created Date]<=Max('Opp and primary quote new' [Created Date])

    )

)


DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO/LIKE!
PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter
Linkedin Profile: Linkedin
YouTube Channel: PowerBI Storytime
Anonymous
Not applicable

jiangmingming_0-1681763183633.png

While still not working

Ahmedx
Super User
Super User

you need to create a calendar and work with it
and try to write like this
FILTER(ALL('Opp and Primary quote New').........

 

 

Accumulated Booking value =
CALCULATE(
[Total Accepted value],
       FILTER(ALL('Opp and Primary quote New')
                 ,'Opp and Primary quote New'[CreatedDate]<= MAXX('Opp and Primary quote New',‘Opp and Pr quote New'[CreatedDate])))

 

 

Anonymous
Not applicable

jiangmingming_0-1681918757028.png

well, still not working

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors