Forum Discussion

sam021083's avatar
sam021083
Frequent Visitor
8 years ago
Solved

desktop

Hello All,   I am facing an issue in creating a custom table using DAX as mentioned below.   I have two tables with below format   I need a new table in the below format using DAX ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi sam021083

     

    I used the SEARCH function to help match.

     

    Table = 
SELECTCOLUMNS(
DISTINCT(
    GENERATE(
        FILTER(ALL('Table1'[Flag]),LEN('Table1'[Flag])>0) ,
        FILTER(
            'Table2',
            SEARCH('Table2'[Exception],'Table1'[Flag],1,0)>0 && LEN(TRIM('Table2'[Exception]))>0) 
            )
            )
 ,"Flag" , [Flag] , "Exception" , [Exception])

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi sam021083

 

I used the SEARCH function to help match.

 

Table = 
SELECTCOLUMNS(
DISTINCT(
    GENERATE(
        FILTER(ALL('Table1'[Flag]),LEN('Table1'[Flag])>0) ,
        FILTER(
            'Table2',
            SEARCH('Table2'[Exception],'Table1'[Flag],1,0)>0 && LEN(TRIM('Table2'[Exception]))>0) 
            )
            )
 ,"Flag" , [Flag] , "Exception" , [Exception])

sam021083's avatar
sam021083
Frequent Visitor
8 years ago

Hi Phil_Seamark

 

This worked like a miracle. Awesome!