Forum Discussion
Solved
Creating entries in Table A from Table B
Dear experts, I´m a newby on Power BI /Power Query and I hope, you can help me to solve my problem. Thx in advance. I have two tables (Table A and Table B) and I´d like to use B to create entries i...
I'd do it in several steps:
- create a subquery containing all distinct customer values
- do a cross join with the category table (get each combination of customer/category exactly once)
https://learn.microsoft.com/en-us/power-query/cross-join - do a full outer join on your example "Table1" with the result query of step 2. Use columns Customer and Category as join criteria
- add custom columns which contain the correct results from each part of the join
- delete unnecessary indermediate columns
HI,
thx for your help and sorry for my late reply. It worked for me.
