Forum Discussion
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 ...
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)
Hi bilingual ,
You will need SEARCH ,MID, LEFT functions to extract the value.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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)
Hi, very quick question, will it be better to use RIGHT, MID or LEFT in terms of memory compared to SEARCH, when i know the position of each variable?
