Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I need your help in solving the below problem.
Need to find out the running total based on selected year and show by month,here is sample data.
Thanks,
Raj
Solved! Go to Solution.
Hi,
Please try the formula.
Running total =
CALCULATE(
SUMX(
SUMMARIZE( Sheet1, [Month], "_test", [Test] ),
[Test]
),
FILTER(
ALLSELECTED(Sheet1),
Sheet1[Month] <= MAX([Month])
)
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
Try the following formula:
Cumulative_Actual =
CALCULATE (
SUM ( Sheet1[Values] ),
FILTER( ALL (Sheet1 ),
Sheet1[Month] <= MAX( Sheet1[Month] ))
)
Just to give you more information, the test field is a calculated measure of average of 4 year.
Hi,
Please try the formula.
Running total =
CALCULATE(
SUMX(
SUMMARIZE( Sheet1, [Month], "_test", [Test] ),
[Test]
),
FILTER(
ALLSELECTED(Sheet1),
Sheet1[Month] <= MAX([Month])
)
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous
It is a bit confusing now.
Do you require cumulative total across 12 months on a selected year; based on the initial description?
or Average across selected years ... and cumulative sum on this average, across months?
If you could send a sample table of how you want the output table to look like that would be great
this is what i am seeing in the output after implementing.
Hi @Anonymous
Did you try to use this pattern:
https://www.daxpatterns.com/cumulative-total/
Please add the sample data or .pbix file without personal information and I will try to help you.
_______________
If I helped, please accept the solution and give kudos! 😀
Here i want to show cummulative for each year by month.
I tried it but it is not giving the righ result.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |