Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
64
Views
Topic starter
I have customers with a few different accounts. The Main Account is Partner and the sub accounts are Customer. In Excel I can use the =TRANSPOSE(FILTER(U2:U816,T2:T816=A2,0)) and it will filter across
Partner Code Customer1 Customer2 Customer3
010022 0100420 0100422 3600700
010026 0110050
I am trying to set it up on Power Query so it will automatically update but I can't get the right function.
Posted : 14/05/2025 12:57 am
I've added the Excel formulas to your file so that I could compare the PQ outcome. The query is quite basic though requires some manipulation of the M-code beyond just clicking in the user interface.
See if you can follow the steps. If you run into problems, just come back here.
Posted : 14/05/2025 2:29 pm
