Running Total in Power Bi (Cumulative)
Budget: $10 – $30 USD
I need formula that calculate total in cumulative way in power bi (See attached "Expected or Wanted Results").
Attached "cumulative" is the result from the following DAX (Please fix):
Cumulative =
var progress=CALCULATE(SUM('FactTableMay'[Progress Trend]),FILTER(ALLSELECTED(FactTableMay[Project ETC]),ISONORAFTER('FactTableMay'[Project ETC],MAX('FactTableMay'[Project ETC]),DESC)))
var totalprogress=CALCULATE(SUM('FactTableMay'[Progress Trend]),ALLSELECTED(FactTableMay))
return DIVIDE(progress,totalprogress)
Attached "cumulative" is the result from the following DAX (Please fix):
Cumulative =
var progress=CALCULATE(SUM('FactTableMay'[Progress Trend]),FILTER(ALLSELECTED(FactTableMay[Project ETC]),ISONORAFTER('FactTableMay'[Project ETC],MAX('FactTableMay'[Project ETC]),DESC)))
var totalprogress=CALCULATE(SUM('FactTableMay'[Progress Trend]),ALLSELECTED(FactTableMay))
return DIVIDE(progress,totalprogress)