Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@Anonymous you cannot have conditional join, what is your end goal?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Yes, you data is right. I wanted to acheive this in power query rather than in measure.
but thanks for your help...
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.
@Anonymous it will be easier if you throw sample data and expected output.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 you cannot have conditional join, what is your end goal?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |