Forum Discussion

relentless226's avatar
relentless226
Regular Visitor
5 years ago
Solved

Custom column help- custom column based on multiple conditions

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 ...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    relentless226 

    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.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

relentless226 

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.