dax formula for non related table

[jimpatel]

Hi,

Thanks for looking at my post.

I have two non related table. Is  there any way to do the following pleasE?

thanks a lot

[jimpatel]

Perfect. Much appreciated and thanks a lot 

[Jihwan_Kim · Accepted solution]

Hi, Please check the below picture and the attached pbix file.

It is for creating a new table.

expected result table =
ADDCOLUMNS (
    Table01,
    "Status",
        MAXX (
            FILTER (
                Table02,
                Table02[Order number] = EARLIER ( Table01[Order number] )
                    && Table02[Material] = EARLIER ( Table01[Material] )
                    && Table02[Operation] = EARLIER ( Table01[Operation] )
            ),
            Table02[Status]
        )
)