Reply
Alta88
Helper IV
Helper IV
Partially syndicated - Outbound

Percentage of Completed Projects

How would I create a measure to show how many projects (as a percentage) have been completed within that latest calendar month?

 

Alta88_0-1721332616066.png

 

1 ACCEPTED SOLUTION
Alta88
Helper IV
Helper IV

Syndicated - Outbound

Yes, here's the data again: 

 

Alta88_0-1721424242839.png

 

View solution in original post

5 REPLIES 5
v-heq-msft
Community Support
Community Support

Syndicated - Outbound

Hi @Alta88 ,
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

vheqmsft_0-1721639513409.png
Create a measure

Percentage = 
VAR _coutRows = COUNT('Table'[Project ID])
VAR _rows = 
CALCULATE(
    COUNT('Table'[Project ID]),
    FILTER(
        'Table',
        'Table'[Status] = "Completed" && 'Table'[Comopleted Date] >= DATE(YEAR(TODAY()),MONTH(TODAY()),1) && 'Table'[Comopleted Date] <= EOMONTH(TODAY(),0)
    )
)
RETURN
_rows/_coutRows

Final output

vheqmsft_1-1721639587408.png

 

Best regards,
Albert He


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

 

Syndicated - Outbound

Cool! Looks like it worked! Thanks for your help!

Alta88
Helper IV
Helper IV

Syndicated - Outbound

Yes, here's the data again: 

 

Alta88_0-1721424242839.png

 

Syndicated - Outbound

@Alta88 

 

Thanks for the data showing completed projects.  That info wasn't in the first image you shared.

 

Just FYI, it's always good practice to provide data for us to help you, not images.  We have to enter all that data into PBI before we can start on a solution.  You'll get a better response from people if you provide data as a file or at least a table in the forum.

 

You also haven't given an example of the desired result.  You say you want 'a measure to show how many projects (as a percentage) have been completed within that latest calendar month' :

 

  • Is that a percentage compared to all projects?
  • A percentage of projects completed compared to their due date 
  • A percentage of projects compared to all projects except those that have a status of 'Submitted', 'Blocked' or 'Awaiting Approval'?
  • Something else?

 

Regards

 

Phil

 



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

Syndicated - Outbound

Hi @Alta88 

 

In your data there isn't anywhere that says when a project is completed.  Need this to do any kind of calculations.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)