Removing Text from Date Format Column

[romovaro]

HI all

I have a column (BPMS-DataRelease) that combines Date format and Text.

What I am trying to achieve is to remove all rows without date format. Trying some of the examples I saw in the forums but not really working so far. Any tip?

THanks

[bhelou · Accepted solution]

Hello , 

try this may help you  : 

in power query change the format of the column to date , then it will give you error , in this step right click on the column and remove the errors , it will delete the rows without date . ( here you will lose data becarefull of this step )