HI experts,
I have a very simple question: I have got a column in my dataset which contains 2 digit numbers, but there are also rows where I have either just a string of alphabets or a combination of alphabets and numbers. All I want to do is to be able to replace cells with alphabets (and numbers) with ‘00’.
New Microsoft Excel Worksheet.xlsx (9.1 KB)
PBI file.pbix (22.4 KB)