Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
I am trying to create column based on available column.
Such as TDLINE ,TDNAME,Test desire result as below.
Requesting any posiblitities in M query please help.
Thanks in advance.
Solved! Go to Solution.
Hello @Bhaskarkolli9,
This is possibile in PowerQuery by doing some adjustments inside a GroupBy option.
Grouping the information by TDNAME you can add a new Column using the Text.Combine function like :
Table.Group(Source, {"TDNAME"}, {{"Desire Result", each Text.Combine([TDLINE],","), type nullable text}, {"All", each _, type table [TDNAME=nullable text, TDLINE=nullable text, Test=nullable text]}})
You can get in this link a PowerBI file with an example : https://we.tl/t-emzQC0kXFv
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
Hello @Bhaskarkolli9,
This is possibile in PowerQuery by doing some adjustments inside a GroupBy option.
Grouping the information by TDNAME you can add a new Column using the Text.Combine function like :
Table.Group(Source, {"TDNAME"}, {{"Desire Result", each Text.Combine([TDLINE],","), type nullable text}, {"All", each _, type table [TDNAME=nullable text, TDLINE=nullable text, Test=nullable text]}})
You can get in this link a PowerBI file with an example : https://we.tl/t-emzQC0kXFv
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
Thanks for your responce.
We still facing the issue like coulmn was not find, but we have column available in table.
Hi @Bhaskarkolli9,
In the Table.Group function you're providing, you are not referencing the previous step (Added Items1), but the "Source" step (as you can see in the picture bellow):
Instead you should have this :
Table.Group(#"Added Items1", {"TDNAME"}, {{"Desire Result", each Text.Combine([TDLINE],","), type nullable text}, {"All", each _, type table [TDNAME=nullable text, TDLINE=nullable text, Test=nullable text]}})
For additional help, please @ me in your reply!
You can also check out my LinkedIn!
Best regards,
Jorge Pessoa
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
11 |