Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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")
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |