merge rows with group by power query
im trying to merge rows values based on equal categories.
for example the following table:
i want to group by the values from column "note" based on the "code" column so the table will look as follow:
is there a way i can do it with power query build in options or it must be function I build my own?
thanks!
excel group-by powerbi
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
add a comment |
im trying to merge rows values based on equal categories.
for example the following table:
i want to group by the values from column "note" based on the "code" column so the table will look as follow:
is there a way i can do it with power query build in options or it must be function I build my own?
thanks!
excel group-by powerbi
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
1
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57
add a comment |
im trying to merge rows values based on equal categories.
for example the following table:
i want to group by the values from column "note" based on the "code" column so the table will look as follow:
is there a way i can do it with power query build in options or it must be function I build my own?
thanks!
excel group-by powerbi
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
im trying to merge rows values based on equal categories.
for example the following table:
i want to group by the values from column "note" based on the "code" column so the table will look as follow:
is there a way i can do it with power query build in options or it must be function I build my own?
thanks!
excel group-by powerbi
excel group-by powerbi
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
asked Nov 13 '18 at 10:15
OrweismanOrweisman
374
374
1
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57
add a comment |
1
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57
1
1
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57
add a comment |
1 Answer
1
active
oldest
votes
To do this in the query editor, you can Group By the code column and then modify the aggregator to use Text.Combine to do the concatenation on the note column.
I've explained this in more detail in the middle step of this answer.
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278667%2fmerge-rows-with-group-by-power-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
To do this in the query editor, you can Group By the code column and then modify the aggregator to use Text.Combine to do the concatenation on the note column.
I've explained this in more detail in the middle step of this answer.
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
add a comment |
To do this in the query editor, you can Group By the code column and then modify the aggregator to use Text.Combine to do the concatenation on the note column.
I've explained this in more detail in the middle step of this answer.
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
add a comment |
To do this in the query editor, you can Group By the code column and then modify the aggregator to use Text.Combine to do the concatenation on the note column.
I've explained this in more detail in the middle step of this answer.
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
To do this in the query editor, you can Group By the code column and then modify the aggregator to use Text.Combine to do the concatenation on the note column.
I've explained this in more detail in the middle step of this answer.
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
answered Nov 13 '18 at 17:50
Alexis OlsonAlexis Olson
13.2k21634
13.2k21634
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278667%2fmerge-rows-with-group-by-power-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
You can achieve this in a pivottable, using a DAX measure (CONCATENATEX). Have a look at my answer to this question
– Marco Vos
Nov 13 '18 at 10:29
@Marco Vos thanks! exactly what i needed!
– Orweisman
Nov 13 '18 at 12:04
I've posted how to do this in the query editor before too. See here or here.
– Alexis Olson
Nov 13 '18 at 14:57