Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi I tried adding a New Column to every table in the Data Column and fill the Company Name which is available in [Column]{0} in the respective table through Custom Column. However Im getting the error as shown in the snip. Please help me on this. Thank You. Please refer attached snip.
Solved! Go to Solution.
Place the following M code in a blank query to see the steps. Note the only change with regard to your version is in the last step, adding custom the column.
let
Source = Excel.CurrentWorkbook(),
#"Removed Columns" = Table.RemoveColumns(Source,{"Name"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Content", "Data"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Table With Company Name", (outer)=> Table.AddColumn(outer[Data],"Company Name", each outer[Data][Column2]{0}))
in
#"Added Custom"
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Place the following M code in a blank query to see the steps. Note the only change with regard to your version is in the last step, adding custom the column.
let
Source = Excel.CurrentWorkbook(),
#"Removed Columns" = Table.RemoveColumns(Source,{"Name"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Content", "Data"}}),
#"Added Custom" = Table.AddColumn(#"Renamed Columns", "Table With Company Name", (outer)=> Table.AddColumn(outer[Data],"Company Name", each outer[Data][Column2]{0}))
in
#"Added Custom"
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Thank You Very Much!! Its working perfectly!
Hi @gmrram
Can you please show the actual error message?
And ideally share the pbix with the table you are working on in PQ
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Thanks for your Reply, here is the Excel file. (link updated)
https://drive.google.com/drive/folders/170LTcgmwt79LqF4KId4CmiZkMT0ZjXLt
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
53 | |
27 | |
15 | |
14 | |
13 |