Forum Discussion

bilingual's avatar
bilingual
Helper V
6 years ago
Solved

Related table with different filter functions

Hi i have a data table with following where i have a lot of entries like:   ENTRY PART OF ENTRY WHICH DEFINES TYPE AAHEPX XXXPX DKDEFX XXXFX 5DKDKE 5XXXX 6EOEEM 6XXXX 7ENEEG ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi bilingual ,

     

     

    Column = SWITCH(
    TRUE(),
    SEARCH("FX",'Table20'[ENTRY],1,0) > 0 , "Public Export",
     SEARCH("7",'Table20'[ENTRY],1,0) > 0 , "Local Export",
      SEARCH("S2OLDC",'Table20'[ENTRY],1,0) > 0 , "Special Export"
)

     

     

    Regards,
    Harsh Nathani
    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi bilingual ,

 

You can use FIND,SEARCH function and a combine them with LEFT ,RIGHT and MID Function in Power BI.

 

Can you share some sample data and expected output.

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)