Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The FabCon + SQLCon recap series starts April 14th at 8am Pacific. If you’re tracking where AI is going inside Fabric, this first session is a can't miss. Register now

Reply
Anonymous
Not applicable

Time Sensitive project count

‎06-13-2022 04:36 AM

Below is a table of data on a few projects. Anytime a projects changes hands, a new line item in added with the date and the stage associated.

 

My question is how can I create a meaure that looks at total Projects assigned by stage for a current date. The issue I am running into is that it only is counting projects with that filtered date stamp. But some projects have been sitting in a stage for a long time so they do not have a upto date stamp. I need a time sensitive Number of Project by stage for anything that was assigned prior to the filtered date.

 

Basically I am trying to measure how many projects per stage were there at the beginning of each month.

 

 

Project IDStage IdCreatedStage_NameIndex
69011394/21/2022Prod Files1
69010314/20/2022Tech Review2
69010864/19/2022Revised Proof3
69011404/14/2022Revised Proof4
69010314/14/2022Tech Review5
69010862/22/2022Revised Proof6
69010312/20/2022Tech Review7
69010222/17/2022Graphics8
69011352/17/2022Estimating9
69010311/28/2022Tech Review10
69010311/28/2022Tech Review11
69010231/28/20221st proof12
69010471/27/2022In Production13
69010221/27/2022Graphics14
69010311/27/2022Tech Review15
114310864/21/2022Revised Proof1
114310244/21/2022Revised Proof2
114311354/19/2022Estimating3
114310864/18/2022Revised Proof4
114310244/18/2022Revised Proof5
114310224/18/2022Graphics6
114310314/18/2022Tech Review7
114311404/12/2022Revised Proof8
114310314/12/2022Tech Review9
114310864/11/2022Revised Proof10
114310244/11/2022Revised Proof11
114310314/8/2022Tech Review12
114310224/7/2022Graphics13
114310313/29/2022Tech Review14
114310863/29/2022Revised Proof15
114310243/29/2022Revised Proof16
114310863/28/2022Revised Proof17
114310313/23/2022Tech Review18
114310223/22/2022Graphics19
114310863/15/2022Revised Proof20
114310233/15/20221st proof21
114310313/7/2022Tech Review22
114310223/4/2022Graphics23
114310863/3/2022Revised Proof24
114310243/3/2022Revised Proof25
114310863/2/2022Revised Proof26
114310313/2/2022Tech Review27
114310312/28/2022Tech Review28
114310212/24/2022Graphics29
114310312/2/2022Tech Review30
114310312/2/2022Tech Review31
114310312/2/2022Tech Review32
114311242/1/2022Estimating33
114310311/28/2022Tech Review34
114310311/21/2022Tech Review35
114311361/20/2022Sent To Client36
114311241/20/2022Estimating37
41610314/21/2022Tech Review1
41610224/20/2022Graphics2
41610863/29/2022Revised Proof3
41610223/29/2022Graphics4
41610313/28/2022Tech Review5
41610223/25/2022Graphics6
41610313/21/2022Tech Review7
41610863/21/2022Revised Proof8
41610313/21/2022Tech Review9
41610863/21/2022Revised Proof10
41610243/21/2022Revised Proof11
41610213/18/2022Graphics12
41610213/17/2022Graphics13
41610213/15/2022Graphics14
41611353/11/2022Estimating15
41610863/9/2022Revised Proof16
41610313/3/2022Tech Review17
41610243/1/2022Revised Proof18
41611353/1/2022Estimating19
41610312/4/2022Tech Review20
41610312/3/2022Tech Review21
41610312/3/2022Tech Review22
41610312/2/2022Tech Review23
41610312/1/2022Tech Review24
41610312/1/2022Tech Review25
41610312/1/2022Tech Review26
41610311/28/2022Tech Review27
41610311/25/2022Tech Review28
41610311/18/2022Tech Review29
41610311/17/2022Tech Review30
416103112/17/2021Tech Review31
416103112/8/2021Tech Review32
416102212/7/2021Graphics33
416103112/3/2021Tech Review34
416106112/3/2021Graphics35
416103112/2/2021Tech Review36
416103111/23/2021Tech Review37
416113311/22/2021Follow up38
416113811/22/2021Scheduling39
416111311/18/2021Clarification40
416102111/17/2021Graphics41
Labels:
Message 1 of 3
508 Views
0
2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

‎06-16-2022 01:39 AM

Hi @Anonymous ,

 

It doesn't seem very clear what your needs are, and what exactly the stage ID field means. For the Stage_name field, what is the complete flow of a project and what status indicates that a project is in a completed or pending state?

Could you further describe your needs and provide relevant explanatory notes. To facilitate me to answer for you as soon as possible.

 

Best Regards,
Henry

 

Message 3 of 3
445 Views
0
Anonymous
Not applicable

‎06-13-2022 04:38 AM

@AlexisOlson I am tagging you because you were able to help me with one of my other issues with this data set.

Message 2 of 3
506 Views
0

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All