Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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