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!
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 ())
See my reports and blog at https://www.datazoepowerbi.com/
View solution in original post
Thank you so much, @DataZoe ! Works perfect!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.