Færdiggjort

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)

Evner: Excel, Matematik, Statistisk analyse, Power BI, Dataindførsel

Om klienten:
( 5 bedømmelser ) Alhassa, Saudi Arabia

Projekt ID: #33776801

Tildelt til:

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 Flere

$30 USD in 2 dage
(10 bedømmelser)
3.8

11 freelancere byder i gennemsnit $20 timen for dette job

ksriniravi

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

$10 USD på 1 dag
(234 bedømmelser)
7.0
DevDataAnalyst

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

$20 USD in 7 dage
(49 bedømmelser)
5.2
(13 bedømmelser)
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 Flere

$30 USD in 2 dage
(9 bedømmelser)
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. Flere

$10 USD på 1 dag
(4 bedømmelser)
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 Flere

$20 USD in 7 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0
Sumta

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

$20 USD på 1 dag
(0 bedømmelser)
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 dage
(0 bedømmelser)
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 dage
(0 bedømmelser)
0.0