How to return first letter from brand field ?

[admin11]

Hi All

I have a field name = Brand

The value label as below :-

Brand

IBM PC

APPLE 

APPLE NOTE BOOK

I expected result as below :-

Brand_New

IBM

APPLE

APPLE

Can some one share with me how to do it ? 

I prefer not to do at power quary.

Paul

[tamerj1 · Accepted solution]

Hi @admin11 
Two methods of doing that https://www.dropbox.com/t/gIx9yLZ98UgzPPbc

New Brand = 
VAR CurrentBrand = Data[Brand]
VAR Length = LEN ( CurrentBrand )
VAR T1 = GENERATESERIES ( 1, Length, 1 )
VAR T2 = ADDCOLUMNS ( T1, "@Letter1", IFERROR ( MID ( CurrentBrand, [Value], 1 ), BLANK ( ) ) )
VAR T3 = ADDCOLUMNS ( T2, "@Letter2", IF ( [@Letter1] = " ", "|", [@Letter1] ) )
VAR NewBrand = CONCATENATEX ( T3, [@Letter2] )
RETURN
    PATHITEM ( NewBrand, 1 )

New Brand 2 = 
VAR CurrentBrand = Data[Brand]
VAR NewBrand = REPLACE ( CurrentBrand, FIND ( " ", CurrentBrand, 1, 100 ), 1, "|" )
RETURN
    PATHITEM ( NewBrand, 1 )

[admin11]

@tamerj1 

Thank you very much , it work. 

So now i understand why people refer to use power quary.

Paul