Function value to Column

[edenekamp]

Hello,

I'am new to Power Bi and have a question. This is my code to get some security product info. This is working. Now i want to add an extra column with the function value (Agent_ID). Can someone help me with this? Thanks a lot.

(Agent_ID as text) =>

let
Api_Token = VSAToken,
Source = Json.Document(Web.Contents("https://euvsa16.kaseya.net/api/v1.0/assetmgmt/audit/" & Agent_ID &"/software/securityproducts?$filter=IsActive eq true and ProductType eq 'Antivirus'",[Headers=[authorization="Bearer "&Api_Token]])),
#"Geconverteerd naar tabel" = Table.FromRecords({Source}),
#"Result uitgevouwen" = Table.ExpandListColumn(#"Geconverteerd naar tabel", "Result"),
#"Result uitgevouwen1" = Table.ExpandRecordColumn(#"Result uitgevouwen", "Result", {"ProductType", "ProductName", "Manufacturer", "Version", "IsActive", "IsUpToDate", "Attributes"}, {"Result.ProductType", "Result.ProductName", "Result.Manufacturer", "Result.Version", "Result.IsActive", "Result.IsUpToDate", "Result.Attributes"})
in
#"Result uitgevouwen1"

[mahoneypat · Accepted solution]

On the Add Column tab in the query editor, you can Invoke Custom Function, choose your function from the dropdown and your [Agent_ID] column as the input. Or you can add a custom column and use fxYourFunction([Agent Column]) too.

Pat