I have one table (Table1) with Customer ID, DOC ID and value, and I’ve managed with multiple merge funtion to generate a new table (Table 2) with all the unique combinations and the sum of the values. But since the number of DOC ID’s per customer is variable, I need to do additional merge in order to have all the combination.
Is there any function in power query that can create a table with all the possibile group combination?
Also I want to create the third table having the Unique ID combinations and the containing ID’s.
Check out this video by @BrianJ , I expect that will solve your query.
If you still need assistance afterwards, provide a sample file with some mock up data and the expected outcome you’re looking for.
Did the response from @Melissa help solve your query?
If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION
If not, please provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.
A perfect initial question includes all of the following:
A clear explanation of the problem you are experiencing
A mockup of the results you want to achieve
Your current work-in-progress PBIX file
Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)
Due to inactivity, a response on this post has been tagged as “Solution”.
If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.