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 f...
  • bhelou's avatar
    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 )