call data in function column

[JordanIT]

Hi everyone, I would like display machines corresponding to each of the lines of this requette.How do you call the functions for each lines ?

[Anonymous]

Hi @JordanIT ,

Thanks for reaching out to our community.

Could you please tell us if your problem has been solved?

If so, please accept the reply as solution and more people will benefit from it.

Thanks.

Best Regards,

Stephen Tao

[Omid_Motamedise]

you can use this function to convert the texts to formula

Expression.Evaluate

[Joe_Barry]

Hi @JordanIT 

Can you provide more information on MachineReferences? Are you calling an API or is it another table? What is the relationship between both tables? Is there a machine ID in the table that you would like to join MachineReferences with?

Generally, if MachineReferences is a table, you can use the Merge Queries feature in Power Query. Choose the table where you would like to join MachineReferences. Select the Merge Queries Option. Choose the columns that share a relationship and press ok. Then click on the icon top right of the column header to open the joined columns from MachineReferences.

If MachineReferences is an API call. You will need to create a function similar to below. You will then in the table click on Add Column and use the function feature and choose this function.

Hope this helps

Joe

let
    GetMachineReferences = (MachineID as text) =>
    let
        Source = Json.Document(Web.Contents("YourAPIURLHere" & MachineID))
    in
        Source
in
    GetMachineReferences

[dharmendars007]

Hello  ,  

In the custom column formula, you'll need to call the function for each row. Typically, if the function is named machinereferences.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

@JordanIT