Return String if / Set-Analysis with text

[Theo_Westseit]

Hello Guys,

Name	Month	Year	Message
Max	1	2022	Yes
Max	2	2022	Maybe
Max	3	2022	Maybe
Max	4	2022	No
Max	5	2022	Yes

Im looking for a way to create a set analysis, but the result isnt a value but a text.
It should be like if Month=5 and year=2022, then 'Yes' else blank.

Would you use a set-analysis for it with 'only' function?

[vinieme12 · Accepted solution]

IF you trying to create a calculated Message field, then use

=IF(Month=5 and Year=2022,'Yes')

OR 

IF you are trying to retrieve the text value from the Message  field that exists in your data , then use

only({<Month={'5'},Year={'2022'}>} Message)

or MaxString({<Month={'5'},Year={'2022'}>} Message)