Tamamlanmış

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)

Beceriler: Excel, Matematik, İstatistiksel Analiz, Power BI, Veri Girişi

Müşteri Hakkında:
( 5 değerlendirme ) Alhassa, Saudi Arabia

Proje NO: #33776801

Seçilen:

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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(10 Değerlendirme)
3.8

Bu iş için 11 freelancer ortalamada $20 teklif veriyor

ksriniravi

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(234 Değerlendirme)
7.0
DevDataAnalyst

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

$20 USD in 7 gün içinde
(49 Değerlendirme)
5.2
(13 Değerlendirme)
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 Daha Fazla

$30 USD in 2 gün içinde
(9 Değerlendirme)
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. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
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 Daha Fazla

$20 USD in 7 gün içinde
(0 Değerlendirme)
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.

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0
Sumta

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

$20 USD in 7 gün içinde
(0 Değerlendirme)
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

$20 USD in 7 gün içinde
(0 Değerlendirme)
0.0