Need Formula

[erhan_79]

Hi there ;

i have a column as below and i need to create a measure like that ;

If [Group Code] column is "30"  give result  "A"

If [Group Code] column is "50"  give result  "B"

ıf not give result "blank"

[amitchandak · Accepted solution]

@erhan_79 , if [group code]  measure the use as is else use max(Table[group code] )

new measure  =

switch( true() ,
max(Table[group code] ) ="30" , "A" ,
max(Table[group code] ) ="50" , "B" ,
blank()
)

[amitchandak]

@erhan_79 , Try a new column like

switch( true() ,
[group code] ="30" , "A" ,
[group code] ="50" , "B" ,
blank()
)

[erhan_79]

dear @amitchandak ;

thank you but , i have a column and want to create a measure , i think your  formula for creating new column 

i can not create a measure from your formula , could you pls check 

thanks