Forum Discussion
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 1 count of update while there are two update in that row.
I'm wondering how can I get the correct count
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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.
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
