If function with text (string)

[PaulPP]

Hello Everyone,

thank you for your help. 

I would like to write a IF function, the result should be text1 or text2. 

Both text have more option for example

text 1 is "a"

text 1 is "b"

text 1 is "c" 

text 2 is "d"

text 2 is "e"

For example: IF[Measure1] = "yes", then text1, otherwise text2 

The problem, text1 has "a","b","c". I would like have "a","b" and "c" in the table

Result should be in a matrix

Does somebody has any idea? Thank you. 

Sorry for my English

Best Regards

Paul

[yyzheng12]

You can consider using a table constructor to create a table and use calculatetable DAX to visualize it.