Hello,
I need some help understanding how to pass a column name as parameter into a custom function.
I have a table (Accounts) from which I need a specific column (No) using a function that will filter that column.
@wdx223_Daniel was kind enough to help me getting the M code for filtering information in that table into another post: Power Query Select rows between two TEXT values
Now I have (partially) failed to create a custom function from his code, because the table name and column name will not be the same every time.
The code should be like this:
let
func = (srcTable as table, srcColumn as text, strStartWith as text, strEndWith as text) as list =>
let
Source = srcTable,
Pas1 = Table.Column(
Table.SelectRows(
Source,
each
let
fx = (txt1, txt2) =>
List.Count(Text.Split(txt1, ".")) = List.Count(Text.Split(txt2, "."))
and
Text.Remove(txt1, ".") <= Text.Remove(txt2, ".")
in
fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)
),
srcColumn
)
in
Pas1
in
func
My problem seems to be on the following line:
fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)
If instead of the parameter srcColum, represeting the source column from the source table (srcTable) that I have to filter & return as list I will put the real name of the column ([No]) as this:
fx(strStartWith, [No]) and fx([No], strEndWith)
...the code will work perfectly, and will return the expected data.
So, Is there a way to pass the column name as parameter?
Kind Regards,
Lucian
