Alisea_MIResolver II5 years agoSolvedConditional Substring 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". E...Show MoreDataZoe5 years agoAlisea_MI You could try a calculated column such as Substring = IF (MID ( Customer[Name] , 3, 1 ) = " ",LEFT ( Customer[Name] , 2 ),BLANK ())
DataZoe5 years agoAlisea_MI You could try a calculated column such as Substring = IF (MID ( Customer[Name] , 3, 1 ) = " ",LEFT ( Customer[Name] , 2 ),BLANK ())
DataZoe5 years agoAlisea_MI You could try a calculated column such as Substring = IF (MID ( Customer[Name] , 3, 1 ) = " ",LEFT ( Customer[Name] , 2 ),BLANK ())
DataZoeMicrosoft Employee5 years agoAlisea_MI You could try a calculated column such as Substring = IF (MID ( Customer[Name] , 3, 1 ) = " ",LEFT ( Customer[Name] , 2 ),BLANK ())
Related contentFind multiple substring DAX CONTAINSSTRINGSubstring in Power BI ?!substringSubstringRank with conditions
