Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
In the power query editor you can add a conditional column.
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
type null
Fantastic, thank you!
If you want a DAX solution (calculated column):
IF(ISBLANK('Table'[Information]), "No", "Yes")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
105 | |
86 | |
72 |