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.
Hey All I have data in the form below
ID | Amount | Month |
1 | 1234 | 1 |
1 | 423 | 3 |
1 | 125 | 5 |
2 | 4352435 | 1 |
2 | 324 | 6 |
2 | 23452 | 32 |
3 | 243 | 1 |
However when I try to run my running total I get this odd graph
So it correctly calculates my the running total until it reaches the end of my data and then plummets to 0 when it should just maintain a straight line infinitely.
My code for the measure is:
Any ideas why my running total is failing after some point and how to solve it?
Note: that I ran the exact same table through an excel pivottable and got nice graph below
Solved! Go to Solution.
@anonymouAsd , Create a new month table
month = generateseries(1,20,1)
join it month in your table and create a measure like
CALCULATE(
SUM('FACT_sales'[Amount]),
FILTER(
ALLSELECTED('month'),
month[Month]<= MAX(month[Month]
)
))
Hi, @anonymouAsd
You can try the following methods.
Amount Incurred running total in Month =
CALCULATE (
SUM ( 'Table'[Amount] ),
FILTER ( ALL ( 'Table' ), [Month] <= MAX ( 'Table'[Month] ) )
)
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@anonymouAsd , Create a new month table
month = generateseries(1,20,1)
join it month in your table and create a measure like
CALCULATE(
SUM('FACT_sales'[Amount]),
FILTER(
ALLSELECTED('month'),
month[Month]<= MAX(month[Month]
)
))
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |