Terminé

Running Total in Power Bi (Cumulative)

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)

Compétences : Excel, Mathématiques, Analyses statistiques, Power BI, Saisie de Données

Concernant le client :
( 5 commentaires ) Alhassa, Saudi Arabia

Nº du projet : #33776801

Décerné à:

ammarqureshi5999

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 Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 2 jours
(10 Commentaires)
3.8

11 freelances font une offre moyenne de 20 $ pour ce travail

ksriniravi

Hi, Good Morning! The following change should work. Just replace " return DIVIDE(progress,totalprogress)" with "return totalprogress" Have a Great Day! Srinivasan

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(234 Commentaires)
7.0
DevDataAnalyst

Check this : [login to view URL] Sales YTD := CALCULATE ( [Sales Amount], DATESYTD( 'Date'[Date] ) )

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(49 Commentaires)
5.2
(13 Commentaires)
3.9
Lukwence

Hi, I encourage you to please read this cover letter with a keen interest to give me a chance to help. I am Lukman, I have read your job details, requirements and the process and I am passionate about becoming a part o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(9 Commentaires)
4.0
IdealExpert

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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
1.8
annapurna360

Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on sim Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
Ravisolanki1993

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
Sumta

Hello! I have done something really similar. Reach out to me. I am available to help with this immediately. Thanks

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
billalshawon99

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
debjyoti101990

I am data entry operator and i have 5 year's experience as data entry operator so you can believe my work

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0