I'm not sure about the logic, but maybe something like this:
sample_table
| extend c = iif(A in ("Q","W","Cat"),"MAP",dynamic(null))
Be aware that Kusto is case sensitive.
Please do not forget to "Accept the answer” wherever the information provided helps you, this can be beneficial to other community members. If you have extra questions about this answer, please click "Comment".