March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
Hi Team,
First of all, thanks for what you are doing.
I have a neewbie issue with Power Query :
i have this table :
Client | Contract |
CLI001 | CTR001 |
CLI001 | CTR002 |
CLI001 | CTR003 |
CLI001 | CTR004 |
CLI001 | CTR005 |
CLI002 | CTR012 |
CLI002 | CTR013 |
CLI003 | CTR003 |
CLI003 | CTR004 |
and i would like to aggregate by Client and have this :
Client | Contract |
CLI001 | CTR001, CTR002, CTR003, CTR004, CTR005 |
CLI002 | CTR012, CTR013 |
CLI003 | CTR003, CTR004 |
i tried with transpose function, divided function but it's not working.
Do you have an idea how we could do that?
Thanks a lot for your help
Br
Marcolen
= Table.Group(Source, {"Client"}, {{"Contract", each Text.Combine(_[Contract], ", ")}})
Change Source to the appropriate step name
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
61 | |
53 | |
26 | |
17 | |
14 |