Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Search function can only return one key value found in a row

The data table I'm dealing with now is like this:   I want to count how many update in column 'Data2', so I use search function. However, as the image shows, the search function return only ...
Need Help
  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    3 years ago

    Hi Anonymous ,

     

    You can use "copy table" in "data view". Please follow these steps.

    Then you can process it in Power Query and try add a custom column as mangaus1111 mangaus1111  suggested.

    I made a sample not the same as yours, but you can reference it.

    Final output:

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mangaus1111's avatar
mangaus1111
Solution Sage
3 years ago

Hi Anonymous ,

try to use this in power query

= Table.AddColumn(#"Changed Type", "Custom", each List.Count(Text.PositionOf([Data 2],"update",Occurrence.All )))

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Suppose the table I want to process was created in power bi, it doesn't appears in power query, what should I do to process it in power query

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    You can use "copy table" in "data view". Please follow these steps.

    Then you can process it in Power Query and try add a custom column as mangaus1111 mangaus1111  suggested.

    I made a sample not the same as yours, but you can reference it.

    Final output:

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.