Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

query to validate rows if dups

hi dears i am facing an problem and i could not solve it in power query    my issue is:     i have a table which contain transaction ID and status. as you see the transaction id is duplicated ( ...
Need Help
  • AmiraBedh's avatar
    AmiraBedh
    2 years ago

    You select both columns > Remove Rows > Remove Duplicates :

    Which is in Power Query : 

    = Table.Distinct(#"yourPreviousStep")
AmiraBedh's avatar
AmiraBedh
Super User
2 years ago

You select both columns > Remove Rows > Remove Duplicates :

Which is in Power Query : 

= Table.Distinct(#"yourPreviousStep")
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    god bless you it works

    • AmiraBedh's avatar
      AmiraBedh
      Super User
      2 years ago

      Glad to help 🙂