Forum Discussion

SantoshKumar's avatar
SantoshKumar
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
Solved

[Text Columns] extract values from one column by applying filter for other column in the same table

Hi,  I have Two columns in my table. 1. Event 2. EventType both are text values. By providing EventType ="ABC" i need to extract values from Event column where "ABC" is one of the eventtype i am...
Need Help
Tips and Tricks
  • themistoklis's avatar
    themistoklis
    7 years ago

    SantoshKumar

     

    Maybe this formula will help:

     

    Column = IF (Table[EventType] = "ABC", TRUE(), FALSE())

    Then on the filter pane you can add everything which is true

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

SantoshKumar

 

Maybe a simple if statement will help?

 

Column = IF (Table[EventType] = "ABC", Table[Event], "")

Then on the filter pane on the right exclude eveyrthing which is blank

  • SantoshKumar's avatar
    SantoshKumar
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    thanks themistoklis

    Actually i used that option and looking for result with only true value (which satisfy the condition).

    • themistoklis's avatar
      themistoklis
      Icon for Community Champion rankCommunity Champion
      7 years ago

      SantoshKumar

       

      Maybe this formula will help:

       

      Column = IF (Table[EventType] = "ABC", TRUE(), FALSE())

      Then on the filter pane you can add everything which is true