Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Column that marks questions

Hello,   I am trying to create a column that marks questions:    Query Question?  Which city Yes Town No What county  Yes City No When was this city founded Yes   ...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    Anonymous 

     

    You can also use the SEARCH function in a column not measure

    Column = 
IF (
    SEARCH ( "What", Sheet1[Query], 1, 0 ),
    "Yes",
    IF (
        SEARCH ( "Which", Sheet1[Query], 1, 0 ),
        "Yes",
        IF ( SEARCH ( "When", Sheet1[Query], 1, 0 ), "Yes", "No" )
    )
)

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

 

You can also use the SEARCH function in a column not measure

Column = 
IF (
    SEARCH ( "What", Sheet1[Query], 1, 0 ),
    "Yes",
    IF (
        SEARCH ( "Which", Sheet1[Query], 1, 0 ),
        "Yes",
        IF ( SEARCH ( "When", Sheet1[Query], 1, 0 ), "Yes", "No" )
    )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This worked, thanks a lot!