Forum Discussion

garye's avatar
garye
New Member
4 years ago
Solved

Removing Duplicates Based on Another Column

Hello,   I am trying to remove unnecessary rows in my data that are essentially incorrect now because there is a more updated row in there and it skews the numbers I am trying to analyze.   I hav...
  • Jihwan_Kim's avatar
    4 years ago

    Hi,

    Please check the attached file below.

    I tried to create a sample pbix file like below, and one of ways to achieve this is to process in Power Query Editor.

    In the sample pbix file, all steps are in the Test load query.