The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
Can someone help me with the right DAX so I can achieve the following result?
For each unique combination of Fruit&Slot in Tabel1, I need to bring the associated "master owner" from Table2, even for the Pear type of fruit.
I believe this screenshot shows all the relevant details, but I can offer more clarification.
Many thanks!
Hello @Anonymous
how are you today ?
if the combination fruit - slot is unique, you can simply create w calculated column in both tables :
new column = table_name[fruit] & " " & table_name[slot]
then link both tables base on this column,
then in the table on the left : create w new column :
column = related ( table_name_to_the_left [ column_name_you_want_to_get])
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that thumbs up button 🫡👍