desktop

[sam021083]

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

[Phil_Seamark · Accepted solution]

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]

Hi @Phil_Seamark

This worked like a miracle. Awesome!