Forum Discussion
Solved
Trying to select rows before expanding data from multiple tables
Here is what I have so far: I am trying to select the rows in each table in the Data column where the Amount column in the inner table is over the cutoff amount. However, I am not sure i...
Hi
with Table.ReplaceValue
= Table.ReplaceValue(#"PreviousStepName",each [CutOff],"",(x,y,z)=>Table.SelectRows(x,each [Amount] > y),{"Data"})Stéphane
Hi
with Table.ReplaceValue
= Table.ReplaceValue(#"PreviousStepName",each [CutOff],"",(x,y,z)=>Table.SelectRows(x,each [Amount] > y),{"Data"})Stéphane
Thank you. I don't understand it, but it works. I understand the concept of a function, but I am not sure how it is getting called or where the parameters come from. Anyway, thank you again.