Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All:
I am new to PowerBI but have some basic programming/SQL skills WAYY back in my career. I am trying to make a custom column called QualityProject using PowerBI that will show either a "Yes" or "No". Here's a representation of my table and the columns that would be involved:
Project Name | ProjectStartDate | ProjectStatus | ProjectResults | CountofTOC |
Here's my psuedocode:
IF ProjectStartDate>=12/1/2019 AND ProjectStatus=Complete AND ProjectResults=Target OR Stretch AND CountofTOC>=1
THEN QualityProject = Yes
ELSE QualityProject = No
I would then like to make a table visual with this that would show the Team Name and a count of the projects where QualityProject = Yes (a team could have multiple projects, some would have Yes in the QualityProject column and some would have No depending on the criteria of the project). I have a Team table that is already related to the Project table in a one to many relationship.
What would be the easiest way to go about all of this in PowerBI? Thanks for any help/advice in advance!
Solved! Go to Solution.
You can create a new column with the following measure:
QualityProject =
IF (
Projects[ProjectStartDate] >= DATE ( 2019, 12, 1 )
&& Projects[ProjectStatus] = "Complete"
&& Projects[ProjectResults] IN { "Target", "Stretch" }
&& Projects[CountofTOC] >= 1,
"Yes",
"No"
)
Then, create a measure to get the count of projects with QualityProject = Yes:
Count = COUNTROWS ( FILTER ( Projects, Projects[QualityProject] = "Yes" ) )
And finally use the table visual to display them.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
You can create a new column with the following measure:
QualityProject =
IF (
Projects[ProjectStartDate] >= DATE ( 2019, 12, 1 )
&& Projects[ProjectStatus] = "Complete"
&& Projects[ProjectResults] IN { "Target", "Stretch" }
&& Projects[CountofTOC] >= 1,
"Yes",
"No"
)
Then, create a measure to get the count of projects with QualityProject = Yes:
Count = COUNTROWS ( FILTER ( Projects, Projects[QualityProject] = "Yes" ) )
And finally use the table visual to display them.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |