Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Removing rows in Power BI

I have a report where two columns represent the time when two different actions started.

I would like to remove the rows of the report that have the same values in these two columns.

The values are depicted in "date, time" format.

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Hi Anonymous,

     

    Power BI has such a function. In Query Editor, select these two columns with "CTRL". Click "Remove Duplicates".

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Dale,

      Thank you for your answer.

       

      My task is a little bit different. Using your first slide, I would have to get rid of 1st and 5th rows as the values in both of the columns are the same ('A' and 'a'). And I would have to keep all the rest rows including 4th and 7st as the values are different (say, 'B' and 'p' in the 2nd row).

       

      Any ideas on that?