March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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)
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])
)
)
While still not working
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])))
well, still not working
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
120 | |
77 | |
60 | |
54 | |
40 |
User | Count |
---|---|
191 | |
103 | |
87 | |
61 | |
50 |