Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have seen posts that explain how to do ackumulated sum from a table column but I need to show ackumulated sum in a table but with a measure as base. Is this possible?
I have a measure that results in column B and now I want to create a measure that gives me column C if shown in a table like below.
Any ideas?
Thanks in advance!
Solved! Go to Solution.
Hi @JohannesM
Please try
Ackumulated =
SUMX (
FILTER ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] <= MAX ( 'Date'[Year] ) ),
[Measure]
)
Hi @JohannesM
Please try
Ackumulated =
SUMX (
FILTER ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] <= MAX ( 'Date'[Year] ) ),
[Measure]
)
Thanks!
Solved within an hour, like always. Man I love this forum ๐
Check out the November 2025 Fabric update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!