Removing rows in Power Bi

[Anonymous]

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.

[v-yulgu-msft]

Hi @Anonymous,

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

New Table =
FILTER ( table, 'table'[time column1] <> 'table'[time column2] )

Best regards,
Yuliana Gu

[Anonymous]

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]

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

[Anonymous]

Hi @v-yulgu-msft, 

Thank you for the advice. All works.