Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create Non Numeric (String) measure using IF and ELSE condition

Something like DATA = If(TableA= "ABCD", "LARGE", "SMALL") I need to create this as a measure because i need to use it in another measure which where i will be using this XYZ and another number cond...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Anonymous,

     

    You can simply add "min" or "max" to the column. Please refer to the snapshot below. BTW, a measure needs the context in the visual.

     

    MeasureName =
IF ( MIN ( Table1[ColumnA] ) = "ABCD", "LARGE", "SMALL" )

     

    Create-Non-Numeric-String-measure-using-IF-and-ELSE-condition

     

    Best Regards,
    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry it should have been  MeasureName = If(Table(ColumnA)= "ABCD", "LARGE", "SMALL")

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

You can simply add "min" or "max" to the column. Please refer to the snapshot below. BTW, a measure needs the context in the visual.

 

MeasureName =
IF ( MIN ( Table1[ColumnA] ) = "ABCD", "LARGE", "SMALL" )

 

Create-Non-Numeric-String-measure-using-IF-and-ELSE-condition

 

Best Regards,
Dale

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks for the reply.. I was able to create the measure with the "min" function on Friday, Appreciate your response.