Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
3 years ago
Solved

Removing Text from Date Format Column

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

Need Help
  • bhelou's avatar
    bhelou
    3 years ago

    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 ) 

1 Reply

  • bhelou's avatar
    bhelou
    Responsive Resident
    3 years ago

    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 )