Suoritettu

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)

Taidot: Excel, Matematiikka, Tilastoanalyysi, Power BI, Tiedonsyöttö

Tietoa asiakkaasta:
( 5 arvostelua ) Alhassa, Saudi Arabia

Projektin tunnus: #33776801

Myönnetty käyttäjälle:

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 Lisää

$30 USD 2 päivässä
(10 Arvostelua)
3.8

11 freelanceria on tarjonnut keskimäärin $20 tähän työhön

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 1 päivässä
(234 arvostelua)
7.0
DevDataAnalyst

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

$20 USD 7 päivässä
(49 arvostelua)
5.2
(13 arvostelua)
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 Lisää

$30 USD 2 päivässä
(9 arvostelua)
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. Lisää

$10 USD 1 päivässä
(4 arvostelua)
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 Lisää

$20 USD 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0