Forum Discussion
How to use expression (x,y,z)
My target is to have multiple steps, as written here:
(
Input_Table as table,
InputColumnToChange1 as text,
InputColumnToChange2 as text
) =>
let
List1 = Input_Table[InputColumnToChange1],
List2 = Input_Table[InputColumnToChange2],
NewTable1 = Table.ReplaceValue (
Input_Table,
each [List1],
each if [List1] = "Bronze"
then "StSt 316L"
else [List1],
Replacer.ReplaceText,
{List1}
),
NewTable2 = Table.ReplaceValue (
NewTable1,
each [List2],
each if [List2] = "Bronze"
then "StSt 316L"
else [List2],
Replacer.ReplaceText,
{List2}
)in NewTable2
I want to invoke them in this way:
let
Source = #"Query1 (2)"(Summary_Volumes, "Body_Material", "Stuffing_Box_Material")
in
Source
but I don't understand why I have the error message:
Could you support me on the error?
Thanks.
If you want my help I don't need your query. I need sample data and expected result based on that.
Sorry, how to add a sample file?
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hello,
here the link :
This is just an abstract of my file, that has almost 500.000 rows.
The target of the function is to get the table in the right. Probably it is not the most efficient way to do that, but understanding why it is not working with a custom function will help me with other cases in the future.
Thanks.
