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.