Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Hi Power BI Users,
Below is a sample table visual, where all attributes are Measures:
Actuals = Sum(Actuals)
Burn Rate Avg = Avg of last 6 months
Burn Rate EAC = If Date<Today, Actuals,Burn Rate Ave
Running Burn = Running Total acorss Burn Rate EAC.
As you can see the Running Burn goes up to May then remains at the May figure for the remainder on the months.
What I want to achieve is for the Running Burn to cumulative the EAC all the way to Dec.
That is Jun = 87.37+20.89 = 108.26; Jul = 108.26+20.89 = 129.15 and so on...
Is there a way to achieve this result?
whats your current statement?
it should be smth like
var _curDate = MAX(Table[Date])
CALCULATE(SUM(Table[EAC]), Table[Date] <= _curDate)
I gave the DAX formual a try and it is returning total which begins several years in the past. I want the Jan figure to be starting from the current year and do a running total from that point
Hi @ThomasT ,
You may create measure like DAX below.
SUM ( Table1[fins_Burn_EAC] ),
ALLSELECTED ( Table1 ),
YEAR ( Table1[Date] ) = YEAR ( MAX ( Table1[Date] ) )
&& MONTH ( Table1[Date] ) <= MONTH ( MAX ( Table1[Date] ) )
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank for the reply.
If you see my table for the months of June to December, it is the same. Why is this?
Is there a way to make the running total to apply for these months as well?
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.