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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lucian
Responsive Resident
Responsive Resident

How to pass column name as parameter into a function

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

 

1 ACCEPTED SOLUTION
Lucian
Responsive Resident
Responsive Resident

After some more digging, I find the answer => Record.Field(_,srcColumn).

So, changing the following line from:

 

fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)

 

to

 

fx(strStartWith, Record.Field(_,srcColumn)) and fx(Record.Field(_,srcColumn), strEndWith)

 

Will  make the code work.

Kind Regards,

Lucian

View solution in original post

2 REPLIES 2
Lucian
Responsive Resident
Responsive Resident

After some more digging, I find the answer => Record.Field(_,srcColumn).

So, changing the following line from:

 

fx(strStartWith, srcColumn) and fx(srcColumn, strEndWith)

 

to

 

fx(strStartWith, Record.Field(_,srcColumn)) and fx(Record.Field(_,srcColumn), strEndWith)

 

Will  make the code work.

Kind Regards,

Lucian

Thanks, this solved a problem for me 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors