cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
DylanBanINT
Helper I
Helper I

Populate a column if another column contains information

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:

 

InformationAnswer
 No
FYes
2Yes
 No
YYes
AYes
4Yes
 No
GYes
2 ACCEPTED SOLUTIONS
Syk
Super User
Super User

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

Syk_0-1661260090350.png

 

Syk_1-1661260113701.png

 

View solution in original post

PVO3
Impactful Individual
Impactful Individual

5 REPLIES 5
Syk
Super User
Super User

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

Syk_0-1661260090350.png

 

Syk_1-1661260113701.png

 

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
Impactful Individual
Impactful Individual

type null

Fantastic, thank you!

PVO3
Impactful Individual
Impactful Individual

If you want a DAX solution (calculated column):

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors