Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Solved!
Table.TransformColumns(#"Grouped Rows", {"AllRows", each FuncionUnaTabla(_) })
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!
Solved!
Table.TransformColumns(#"Grouped Rows", {"AllRows", each FuncionUnaTabla(_) })
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
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |