Find Earliest Date in baseline project

[Anonymous]

Hi All

Scratching my brain on this for a while now;

I have 2 projects, baseline and Current (6 months update of Baseline)

6 months into the project the Actual Cost sit at $30 MIllion.

I would like to create a measure that gives me the DATE where the Baseline would have achieved $30 Million.

In short; the earliest date in Baseline where the planned cost hits $30 M.

I am trying to figure out where the current project stands compared to Baseline.

Please help

[Greg_Deckler]

Need sample data...Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

But, in general you could create a date table either actual or in a measure that has a running total cost column in it and then just filter for the MIN date that is over $30M.

[Anonymous]

Cumulative Actual is $4,027,910 (CURRENT)

Want to create a measure that tells me the date when the BASELINE achieves $4,027,910

Thanks for helping

DATA:

proj_id	proj_short_name	Base and Current	target_start_date	target_end_date	Cumulative Budgeted(Measure)	**bleep** Actual(Measure)
418	HUB-BASE	Baseline	10/16/2017 0:00	10/17/2017 0:00	$326,000
418	HUB-BASE	Baseline	11/30/2017 0:00	12/7/2017 0:00	$88,240
418	HUB-BASE	Baseline	12/8/2017 0:00	12/8/2017 0:00	$11,724
418	HUB-BASE	Baseline	12/8/2017 0:00	12/18/2017 0:00	$132,360
468	HUB-JUN18	Current	12/14/2017 0:00	12/19/2017 0:00	$0	$79,380
418	HUB-BASE	Baseline	12/11/2017 0:00	12/26/2017 0:00	$117,240
418	HUB-BASE	Baseline	12/19/2017 0:00	12/26/2017 0:00	$2,538,228
418	HUB-BASE	Baseline	12/19/2017 0:00	12/28/2017 0:00	$88,240
418	HUB-BASE	Baseline	12/19/2017 0:00	12/29/2017 0:00	$110,300
418	HUB-BASE	Baseline	12/26/2017 0:00	12/29/2017 0:00	$66,470
468	HUB-JUN18	Current	12/18/2017 0:00	12/29/2017 0:00	$0	$119,130
418	HUB-BASE	Baseline	12/29/2017 0:00	1/5/2018 0:00	$88,240
418	HUB-BASE	Baseline	12/19/2017 0:00	1/8/2018 0:00	$134,480
418	HUB-BASE	Baseline	12/29/2017 0:00	1/8/2018 0:00	$53,792
468	HUB-JUN18	Current	1/3/2018 0:00	1/8/2018 0:00	$0	$79,475
468	HUB-JUN18	Current	1/5/2018 0:00	1/8/2018 0:00	$0	$39,725
418	HUB-BASE	Baseline	1/3/2018 0:00	1/9/2018 0:00	$110,300
468	HUB-JUN18	Current	1/4/2018 0:00	1/9/2018 0:00	$0	$79,420
418	HUB-BASE	Baseline	12/19/2017 0:00	1/10/2018 0:00	$175,860
418	HUB-BASE	Baseline	1/8/2018 0:00	1/15/2018 0:00	$99,705
418	HUB-BASE	Baseline	1/8/2018 0:00	1/16/2018 0:00	$110,300
418	HUB-BASE	Baseline	1/15/2018 0:00	1/17/2018 0:00	$66,470
418	HUB-BASE	Baseline	1/12/2018 0:00	1/19/2018 0:00	$110,300
468	HUB-JUN18	Current	1/2/2018 0:00	1/22/2018 0:00	$0	########
418	HUB-BASE	Baseline	1/18/2018 0:00	1/23/2018 0:00	$88,240
468	HUB-JUN18	Current	1/22/2018 0:00	1/23/2018 0:00	$0	$39,680
418	HUB-BASE	Baseline	1/9/2018 0:00	1/25/2018 0:00	$134,480
418	HUB-BASE	Baseline	1/17/2018 0:00	1/25/2018 0:00	$67,240
418	HUB-BASE	Baseline	1/22/2018 0:00	1/29/2018 0:00	$110,300
418	HUB-BASE	Baseline	1/25/2018 0:00	1/30/2018 0:00	$88,240
468	HUB-JUN18	Current	1/29/2018 0:00	1/30/2018 0:00	$0	$39,680
418	HUB-BASE	Baseline	1/30/2018 0:00	2/1/2018 0:00	$44,120
468	HUB-JUN18	Current	1/26/2018 0:00	2/1/2018 0:00	$0	$897,812
418	HUB-BASE	Baseline	1/25/2018 0:00	2/2/2018 0:00	$94,136
418	HUB-BASE	Baseline	2/1/2018 0:00	2/2/2018 0:00	$61,632
468	HUB-JUN18	Current	1/26/2018 0:00	2/2/2018 0:00	$0	$99,294
468	HUB-JUN18	Current	1/26/2018 0:00	2/5/2018 0:00	$0	$99,264
418	HUB-BASE	Baseline	2/2/2018 0:00	2/8/2018 0:00	$19,605
418	HUB-BASE	Baseline	2/5/2018 0:00	2/8/2018 0:00	$61,632
418	HUB-BASE	Baseline	2/1/2018 0:00	2/9/2018 0:00	$110,300
418	HUB-BASE	Baseline	2/2/2018 0:00	2/12/2018 0:00	$110,300

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may research the code generated by Quick measure Running total.