Hi I have a quick question if somebody can help please!!
I have a table1 with columns display number, order number fields..
I have another table2 with order number field..
Now I want to join these two tables with a condition...like below..
First I need to check if table2 order number starts with xy then I need to join that with display number...if not then I need to join with order number...
Thanks for your help
Solved! Go to Solution.
Hi @mpowerrajesh365 ,
According to your description, I create this data：
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))) )
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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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)
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
May the fourth be with you, join us online!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.