Forum Discussion
Solved
Need Formula
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 res...
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()
)
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()
)