The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Solved! Go to Solution.
@Anonymous,
You may research the code generated by Quick measure Running total.
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.
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 |
@Anonymous,
You may research the code generated by Quick measure Running total.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
246 | |
119 | |
114 | |
86 | |
70 |