Forum Discussion

Nikki's avatar
Nikki
Helper II
6 years ago
Solved

Contains Formula

Hi there I have a series of custom columns example:   Concept (result is either pass fail or query) Initiative (result is either pass fail or query) Project (result is either pass fail or query) ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Nikki ,

     

     

    Create a Calculated Column

     

    Status =
SWITCH (
    TRUE (),
    'Table'[Concept] = "Fail"
        || 'Table'[Initiative] = "Fail"
        || 'Table'[Project] = "Fail"
        || 'Table'[Brief] = "Fail", "Fail",
    'Table'[Concept] = "Query"
        || 'Table'[Initiative] = "Query"
        || 'Table'[Project] = "Query"
        || 'Table'[Brief] = "Query", "Query",
    "Pass"
)

     

     

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

AntrikshSharma's avatar
AntrikshSharma
Community Champion
6 years ago

Maybe try something like this:

Status =
VAR FinalString =
    CONCATENATEX (
        FILTER ( Nikki, Nikki[Num] = EARLIER ( [Num] ) ),
        [Concept] & [Initiative] & [Project] & [Brief]
    )
VAR LowerString =
    LOWER ( FinalString )
VAR PassIncluded =
    SEARCH ( "pass", LowerString, 1, 0 )
VAR QueryIncluded =
    SEARCH ( "query", LowerString, 1, 0 )
VAR Result =
    SWITCH ( TRUE (), QueryIncluded > 0, "Query", PassIncluded > 0, "Pass", "Fail" )
RETURN
    Result

  • Nikki's avatar
    Nikki
    Helper II
    6 years ago

    thanks so much !!