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

Please help.

 

Thanks,

Sam

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])

2 Replies

  • 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])