I had one query in using the IF as explained in the Blog. After loading the attached excel file comprising sales number using Power Query, if Column 1 has contents (Text and numbers both i.e. Store name at the beginning followed by numbers and again store name followed by numbers) and if we want to fill only text below it wherever the numbers are present until you reach a text. I tried using t[Image Can Not Be Found]he above guidelines, but could not. Could you please guide?
Thank you,
Hi Arvind,
Try this formula in a new custom column:
if (try Number.From([Column3]) otherwise "Text") ="Text" then "Text Found" else null
You can replace "Text Found" with [Column3] if you want to return the text found.
(columns 1 and 2 are empty, I assume you are referring to column 3 instead of column 1 in your description)
Cheers,
Catalin
