Forum Discussion
Apply a function to each Table Record
Hi
I have grouped record in a way that for each row I get some columns, and one of this columns is of the type "Table".
I want to transform each table using a function, and then Merge all of this tables in just one.
How can I do that?
- Anonymous6 years ago
Solved!
Table.TransformColumns(#"Grouped Rows", {"AllRows", each FuncionUnaTabla(_) })
3 Replies
- edhansCommunity Champion
You are going to need to give WAY more info, and preferably the source file (sample data) and your existing M code to date, as well as what the expected output would look like.
How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum - AnonymousNot applicable
I've found how to apply a function to each row, but adding a New Column.
I don't want to add a new column, instead I want to Transform the AllRows columns.
How can I change this code to replace instead of adding a new column?
#"Added Custom1" = Table.AddColumn(#"Grouped Rows", "Custom", each FuncionUnaTabla([AllRows]))I've tryied with:
= Table.TransformColumns(#"Grouped Rows", each FuncionUnaTabla([AllRows]))but I get the following error: "Expression.Error: We cannot convert a value of type Function to type List"
Any idea about how to change this?
Thanks!
- AnonymousNot applicable
Solved!
Table.TransformColumns(#"Grouped Rows", {"AllRows", each FuncionUnaTabla(_) })