Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hi,
I need to set up a conditional column, which looks at the first three characters in a text column and if the third character is " ", it should return the first two characters, else "null".
Example: ZW BY 34 should return ZW. SSRS 43 YT should return "null".
Would be grateful for any input on this!
Solved! Go to Solution.
@Alisea_MI You could try a calculated column such as
Substring = 
IF (
MID ( Customer[Name] , 3, 1 ) = " ",
LEFT ( Customer[Name] , 2 ),
BLANK ()
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@Alisea_MI You could try a calculated column such as
Substring = 
IF (
MID ( Customer[Name] , 3, 1 ) = " ",
LEFT ( Customer[Name] , 2 ),
BLANK ()
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 91 | |
| 49 | |
| 37 | |
| 31 | |
| 30 |