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))
Hi, I am an ACCA member and have more than 10 years of experience in professional consultancy regarding Microsoft Excel and Power Bi. I am an expert in formulating scenarios, logic, and criterial outputs based on user Daha Fazla
Bu iş için 11 freelancer ortalamada $20 teklif veriyor
Hi, Good Morning! The following change should work. Just replace " return DIVIDE(progress,totalprogress)" with "return totalprogress" Have a Great Day! Srinivasan
Running Total in Power Bi (Cumulative) This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices. Daha Fazla
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.
Hello! I have done something really similar. Reach out to me. I am available to help with this immediately. Thanks
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.