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: 

 

QueryQuestion? 

Which city

Yes
TownNo

What county 

Yes
CityNo
When was this city foundedYes

 

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? 

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" )
    )
)

     

4 Replies

  • 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! 

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    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
     
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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