Multiple table join with conditions

I have two columns from which I need to identify which column I need to join to. Basically I am trying to get the below dax converted into power query 

IF(LEFT('Table1'[OrderNumber],2) = "XY", Table2[quote_number],
Table2[order_number]) = Table1[OrderNumber] && table2[order_date] > DATEADD('table1'[CREATED],-1,MONTH)

Anonymous it will be easier if you throw sample data and expected output.

Hi  Anonymous  ,

According to your description, I create this data：

Table1：

Table2：

Here are the steps you can follow：

1. Create measure.

Measure = 
IF(
    LEFT(MAX('Table2'[order number]),2)="xy",
    CALCULATE(MAX('Table1'[display number]),FILTER(ALL('Table1'),[order number]=MAX([order number]))),
    CALCULATE(MAX('Table1'[order number]),FILTER(ALL('Table2'),[order number]=MAX([order number])&&[order date]>DATEADD('Table1'[created],-1,MONTH)))
    )

2. Result

You can downloaded PBIX file from here.

If my answer is not what you want,can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Yes, you data is right. I wanted to acheive this in power query rather than in measure. 

but thanks for your help...