Forum Discussion

dgdgdg122db's avatar
dgdgdg122db
Helper II
6 years ago
Solved

two conditions return text

Hi , I am creating a table to show which customers downloaded and requested what kind of documents on which date. I want to use a measure to return a text result, when Event Action = "submit" and E...
Need Help
Show and Tell
  • az38's avatar
    az38
    6 years ago

    Hi dgdgdg122db 

    you dont need to create a measure, create a calculated column like

    Column = 
IF([Event Action] = "submit" && [Event Catagory] = "request info", [Event label], BLANK() )
az38's avatar
az38
Community Champion
6 years ago

Hi dgdgdg122db 

you dont need to create a measure, create a calculated column like

Column = 
IF([Event Action] = "submit" && [Event Catagory] = "request info", [Event label], BLANK() )