Forum Discussion
jabrillo
Helper I
Helper IMonthly Burn Rate
I want to create a line chart of monthly burn rate. This is how my file looks like: Period Actual Cost 1 100 2 120 3 140 4 100 This is what I want to accomplish: Period ...
why should it be a measure? Can it be impacted by user filters?
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
Greg_Deckler
Community Champion
Community Championjabrillo Try:
Burn Rate =
VAR _Period = MAX( 'Table'[Period] )
VAR _Table = FILTER( ALL( 'Table' ), [Period] <= _Period )
VAR _ActualCost = SUMX( _Table, [Actual Cost] )
VAR _BurnRate = DIVIDE( _ActualCost, _Period )
RETURN
_BurnRate
jabrilloThe table would also have Project ID as another column. So the table looks like this:
Project ID Period Actual Cost