Populate a column if another column contains information

[DylanBanINT]

Hi, basically all I need is for a new column to check if an existing column contains either text or number and it if does it says Yes and if it doesn't it says no. 

Tried to google this but cannot get anything that matches what I need.

Example below:

Information	Answer
	No
F	Yes
2	Yes
	No
Y	Yes
A	Yes
4	Yes
	No
G	Yes

[Syk · Accepted solution]

In the power query editor you can add a conditional column.

[Syk · Accepted solution]

In the power query editor you can add a conditional column.

[DylanBanINT]

Hi, unfortunately I am getting an error saying I must enter 'a number value' into the Value box and will not let me click ok

[PVO3 · Accepted solution]

type null

[DylanBanINT]

Fantastic, thank you!

[PVO3]

If you want a DAX solution (calculated column):

IF(ISBLANK('Table'[Information]), "No", "Yes")