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.
lbendlin
Super User
Super User
Burn Rate =
var p = [Period]
return DIVIDE(SUMX(FILTER('Table',[Period]<=p),[Actual Cost]),p)
