Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
Power query learner here. I am trying to create a custom function. I have a table which after initial processing still contains column headers that start with the text "Column". I wanted to invoke this function on the last step so then I can get rid of all these columns that start with "Column".
I used below function but what it is doing is returning a table with all columns that start with "Column" text rather than removing it. Any idea how to fix this?
(InputQueryTable as table) =>
let
Source = #"InputQueryTable",
#"Column Names" = Table.ColumnNames(Source),
#"Columns Containing String" = List.FindText(#"Column Names", "Column"),
//#"Columns Containing String" = List.Contains( #"Column Names", "", Text.StartsWith( "Column") ),
//#"Columns Containing String" = List.FindText(#"Column Names", Text.StartsWith( "Column") ),
#"List Difference" = List.Difference( #"Column Names", #"Columns Containing String"),
#"Removed Columns" = Table.RemoveColumns(Source, #"List Difference")
in
#"Removed Columns"
Solved! Go to Solution.
Hi,
found the answer myself. Updated code below.
sum(Earned Hours ) / Sum(CurrentEst)
(InputQueryTable as table) =>
let
Source = #"InputQueryTable",
#"Column Names" = Table.ColumnNames(Source),
#"Columns Containing String" = List.FindText(#"Column Names", "Column"),
#"Removed Columns" = Table.RemoveColumns(Source, #"Columns Containing String")
in
#"Removed Columns"
Hi,
found the answer myself. Updated code below.
sum(Earned Hours ) / Sum(CurrentEst)
(InputQueryTable as table) =>
let
Source = #"InputQueryTable",
#"Column Names" = Table.ColumnNames(Source),
#"Columns Containing String" = List.FindText(#"Column Names", "Column"),
#"Removed Columns" = Table.RemoveColumns(Source, #"Columns Containing String")
in
#"Removed Columns"
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!