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):
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))
11 freelanceria on tarjonnut keskimäärin $20 tähän työhön
Hi, Good Morning! The following change should work. Just replace " return DIVIDE(progress,totalprogress)" with "return totalprogress" Have a Great Day! Srinivasan
Being a specialist Data Entry Operator, I can complete all your projects at ease. I am a workaholic and skilled enough to carry out all your projects successfully.
Assalamualaikum, I saw the 2 samples you provided. Ins-ha Allah I will be able to complete 100 percent of the work according to the given sample. There is some excel function On which I have good experience.