Forum Discussion

SarathB2's avatar
SarathB2
Frequent Visitor
4 years ago
Solved

Need help with Dax

Hello Experts, Good Day! I am stuck with finding  and extract the values from  a column which "StartsWith" any of the value from another column which are true. Example -  I have two tables with o...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    SarathB2 , Try like

     

    Flag =
    VAR SO = Table2[Object]
    VAR _Tab = maxx(FILTER(Table1, CONTAINSSTRING(LEFT(SO,LEN(Table1[Type])),Table1[Type])), Table[Type])
    RETURN
    _tab

  • Fowmy's avatar
    Fowmy
    4 years ago

    SarathB2 

    Try the following column:

    Item = 
VAR SO = Table2[Object]
VAR Tab = VALUES('Table1'[Type] )
RETURN
IF(
    Table2[Flag],
    MAXX(
        FILTER(
            Table1,
            CONTAINSSTRING( SO , Table1[Type] )
        ),
        Table1[Type]
    )
)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

SarathB2 , Try like

 

Flag =
VAR SO = Table2[Object]
VAR _Tab = maxx(FILTER(Table1, CONTAINSSTRING(LEFT(SO,LEN(Table1[Type])),Table1[Type])), Table[Type])
RETURN
_tab

  • SarathB2's avatar
    SarathB2
    Frequent Visitor
    4 years ago

    Hello amitchandak ,

     

    Thanks a lot, it's working perfectly. Greaful for Quick response.

    Regards,
    Sarath.

  • SarathB2's avatar
    SarathB2
    Frequent Visitor
    4 years ago

    Hello amitchandak , Fowmy 

    In my case , one of Type is "ANG" 
    when i try to search that one "ANGULAR" also consedering in Object as pass as it is staring with ANG.
    how to avoid this .....
    I tried to give a space after ANG like "ANG " but when its come to Desktop its not taking the space .

    Please assist,

    Thanks in advance.

    • Fowmy's avatar
      Fowmy
      Icon for Super User rankSuper User
      4 years ago

      SarathB2 

      I modified my code, now you do not need the Flag column.

      Item = 
VAR SO = Table2[Object]
VAR Tab = VALUES('Table1'[Type] )
VAR Obj = 
    IF( SEARCH(" ", Table2[Object],1,BLANK()) = BLANK(),
        Table2[Object],
        TRIM(LEFT( Table2[Object] , SEARCH(" ", Table2[Object],1,BLANK()) ))
    )
VAR Result = 
MAXX(  FILTER(ALL('Table1'[TYPE]), Table1[Type] = OBJ) , Table1[Type] )

RETURN
   Result