Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Dear,
I have the following table:
Where I'd like to create a column with the cumulative sum of the "YTD_Actuals_per_project" in fuction of distinct values for "Project_Act"
Hope I was clear enough.
Thnaks in advance for your support.
Hi @Yazid - We will use measure for Metrics, can you please try to create a new measure using below calculation
Cumulative YTD Actuals =
CALCULATE(
SUM('YourTableName'[YTD_Actuals_per_project]),
FILTER(
ALLSELECTED('YourTableName'),
'YourTableName'[Project_Act] <= MAX('YourTableName'[Project_Act])
)
)
you can create a measure that calculates the cumulative sum of YTD_Actuals_per_project based on distinct Project_Act values and drag and drop on report view and check the results. it works
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Dear,
Thanks for you reply ! However, it should be an increasing function like the green curve..
Should I try something else ?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |