Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 in A. At the end I´d like to have one row for each category for each customer. If the row got created, the the value should be "0". I hope, I was able to explain my issue. Below the tables as example
Table 1 | ||
customer | category | value |
a | aa | 12 |
a | dd | 5 |
b | ee | 21 |
c | bb | 29 |
c | ff | 21 |
Tabel 2 |
category |
aa |
bb |
cc |
Final | ||
customer | category | value |
a | aa | 12 |
a | bb | 5 |
a | cc | 0 |
b | cc | 21 |
b | aa | 0 |
b | bb | 0 |
c | bb | 29 |
c | cc | 21 |
c | aa | 0 |
Thank you
Solved! Go to Solution.
I'd do it in several steps:
HI,
thx for your help and sorry for my late reply. It worked for me.
why in the final table b, bb is 21 and c, cc is 21? could you pls explain how to get the output?
Proud to be a Super User!
Hi,
I´m sorry for this confusion. This is just an issue on copy & paste on creating the test table
Does @AMeyersen 's solution work for you? if not ,pls correct the expected output.
Proud to be a Super User!
HI,
thx for asking. I didn´t find the time yet to test it, but I´ll leave a comment, when tested.
I'd do it in several steps:
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |