cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Call custom column into a function

Hello community,

I have a list of URL's in a custom column in Table 1 extracted from a webside. Also, I want to extract data from each link in the list creating a Table 2 and then converted it in a function. Is there any chance to call that custom column into my function using DAX coding that allows me to put out Table 2?

(Address as text) as table =>

let
Source = Web.BrowserContents("https://website.com/address/numbers", [WaitFor=[Timeout=#duration(0, 0, 0, 2)]]),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", ".key-row-bg-colour .tbl-row-cell-heading"}, {"Column2", ".key-row-bg-colour TD"}}, [RowSelector=".key-row-bg-colour"]),
#"Changed Type" = Table.TransformColumnTypes(#"Extracted Table From Html",{{"Column1", type text}, {"Column2", type text}})
in
#"Changed Type"


"https://website.com/Different_addressess_from_customColumn/different_numbers_from_customColumn" I do not know if that makes sense to anybody, I am still a newbie.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Hello

 

this would be quite difficult to describe to newbie.

You can create a basic function to extract the data from such a website https://website.com/Different_addressess_from_customColumn/different_numbers_from_customColumn"  using two parameters to build the complete path. Then use the new function and add a new column with the function, imputing values of 2 different columns to feed the function. function could look like

 

(addresscustomcolumn, numberscustomcolumn) =>

let

    webresult = ource = Web.BrowserContents("https://website.com/" & addresscustomcolumn & "/" & numberscustomcolumn etc....

 

Hope you got an idea how to work it out

Good look

Jimmy

View solution in original post

4 REPLIES 4
Super User II
Super User II

Hello

 

this would be quite difficult to describe to newbie.

You can create a basic function to extract the data from such a website https://website.com/Different_addressess_from_customColumn/different_numbers_from_customColumn"  using two parameters to build the complete path. Then use the new function and add a new column with the function, imputing values of 2 different columns to feed the function. function could look like

 

(addresscustomcolumn, numberscustomcolumn) =>

let

    webresult = ource = Web.BrowserContents("https://website.com/" & addresscustomcolumn & "/" & numberscustomcolumn etc....

 

Hope you got an idea how to work it out

Good look

Jimmy

View solution in original post

Anonymous
Not applicable

Well, It took me a while to understand the process but I made it work. Thanks for the help.

If my post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

However, come back if you need further assistance

 

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors