cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KD_PBI_DA100
Advocate II
Advocate II

Help with Custom Function

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"

 

 

1 ACCEPTED SOLUTION
KD_PBI_DA100
Advocate II
Advocate II

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"

 

View solution in original post

1 REPLY 1
KD_PBI_DA100
Advocate II
Advocate II

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"

 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Top Kudoed Authors