Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Removing rows in Power Bi

In my Power BI report I have two columns that represent the time when two different actions started.

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

The values have date-time format.

4 Replies

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

    Hi Anonymous,

     

    You can filter out those rows in a new calculated table.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi v-yulgu-msft, 

       

      Thank you for the advice. All works.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi v-yulgu-msft,

       

      It seems that the issue is still present.

      Here is the formula that I modified: 

       

      Table = FILTER (TourTbl, 'TourTbl'[DT_Created] <> 'TourTbl'[DT_Started] )

       

      And the result is as follows:

       

      DT_Created and DT_Started still have the same values.

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

         

        Did you drag columns [DT_Created] and [DT_Started] from the new calculated table into visual? Could you share the pbix file for further analysis?

         

        Regards,
        Yuliana Gu