Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

merge data with 3 columns and list result

Hi team,

 

I have been trying to solve the below but for some reason, I cannot find a way...any help would be of great help. Attached is a sample workbook for reference. The workbook has the following, the first table has products with a combination of products, these are combinations that are not allowed when a new product is requested. 

 

Table 1:

Product 1Product 2
ABCDEF
ABCGHI
ABCJKL
DEFZYX
DEFMNO
ZYXABC
ZYXJKL
ZYXDEF

 

The 2nd table includes sales person and their products for which they are responsible to sell.

 

Table 2:

Sales PersonProducts
John DoeDEF
John DoeGHI
John DoeMNO

 

There would be a form where a sales rep can request a new product to be included in his / her catalog, The check that is required to be perform is to verify if the products already in the catalog i.e., table 2 and the newly requested is a combination that is not part of the combination in table 1. If the product requested is a combination from table 1 after looking in to the existing values, then it should be denied else output should be granted. 

 

Following is a sample of the table with output.

 

Input by user(s)Output
RequestorRequested Product 
John DoeABCDenied

 

The output result is denied as the requested Product ABC with combination DEF which is already part of the user catalog in table 2 is not a valid combination. Any suggestion, help will be of great help here.

 

Regards,

A!

 

https://1drv.ms/u/s!Aj7kf6Fnqc5SyTIwwHjuCtcHIRJT?e=XT7LtZ

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

Hi, @Anonymous , you might want to try this solution (attached file)

Untitled.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @CNENFRNL ,

Thank you for having this resolved for me. The output of the results are as expected and it works like a charm. The only thing that I have as an issue is that the list for me is exhaustive for each product with more than 80 + combinations and the results take approximately 2 minutes to list down values. Having said this, for now this should help.

 

Thanks a ton.

 

Regards,

A!

CNENFRNL
Community Champion
Community Champion

Hi, @Anonymous , you might want to try this solution (attached file)

Untitled.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors