Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
gmrram
Regular Visitor

Fill a specific cell value to entire column for a Table through Custom Column

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.PQ issue.jpg

1 ACCEPTED SOLUTION
AlB
Super User
Super User

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"

 

 

SU18_powerbi_badge

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.

 

View solution in original post

4 REPLIES 4
AlB
Super User
Super User

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"

 

 

SU18_powerbi_badge

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.

 

gmrram
Regular Visitor

Thank You Very Much!! Its working perfectly!

AlB
Super User
Super User

Hi  @gmrram 

Can you please show the actual error message?

And ideally share the pbix with the table you are working on in PQ

 

SU18_powerbi_badge

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.

 

 

gmrram
Regular Visitor

Thanks for your Reply, here is the Excel file. (link updated)

 

https://drive.google.com/drive/folders/170LTcgmwt79LqF4KId4CmiZkMT0ZjXLt

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors