Column that marks questions

[Anonymous]

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

I think it should consist of DAX expression CONTAINSTRING in combination with 'when', 'which' etc. yet I don't know how to write the code

Any idea how to do this? 

[v-henryk-mstf]

Hi @Anonymous ,

If your question has been resolved, please mark the correct response as the standard answer to help the other members find it more quickly.

If there is still a problem, please point it out and I will answer it for you as soon as possible.

Best Regards,
Henry

[themistoklis · Accepted solution]

@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]

This worked, thanks a lot! 

[selimovd]

Hey @Anonymous ,

that's difficult to say when you don't tell us how the data looks like.

But something like this might work:

Question =
IF(
    CONTAINSSTRING(
        'myTable'[Query],
        "which"
    ),
    "Yes",
    "No"
)

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic