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 Event Catagory is "request info"

Return: Event label (text) 

Can someone help me, please?

 

  • 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() )

2 Replies

  • az38's avatar
    az38
    Community Champion

    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() )
  • The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.