Forum Discussion
romovaro
3 years agoResponsive Resident
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...
- 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 )
bhelou
3 years agoResponsive Resident
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 )