Forum Discussion
dgdgdg122db
Helper II
6 years agotwo 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
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() ) - amitchandak
Super User
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.