Forum Discussion
Filtering out data based on column entry based on TEXT
Hello, I am looking for the best way to filter out data based on a text entry. I will provide an example that should help explain what I'm trying to get at. Account ID Valu...
Ok, this is super quick and dirty.
It seems that the Account # and ID are always the same when there is duplication with DataA and DataB, so I grouped on Account#, then took the FIRST value in ID., then merged it with itself.
See it in the Power Query window.
edhans
Community Champion
Community ChampionOk, this is super quick and dirty.
It seems that the Account # and ID are always the same when there is duplication with DataA and DataB, so I grouped on Account#, then took the FIRST value in ID., then merged it with itself.
See it in the Power Query window.