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 am using the function = Table.Unpivot(#"Filtered Rows1", {"x","y","z"...}, "Attribute", "Value") to unpivot a table by those selected rows.
However, they are input values and will change and when they change I get the error that a column header is missing.
How do I write this in a way that -instead of listing out the column headings to unpivot {"x","y","z"...}, I can select all columns beginning with column 4 to the end. Is it doable?
Regards
Solved! Go to Solution.
Something like:
= Table.Unpivot(#"Filtered Rows1", List.RemoveFirstN(Table.ColumnNames(#"Filtered Rows1"),3), "Attribute", "Value")
Hi @kgiboin ,
Flip the operation on its head: Select all the columns you DON'T want to unpivot, then go to Transform tab > Unpivot Columns (dropdown) > Unpivot OTHER columns.
This will generate code like this instead:
Table.UnpivotOtherColumns(previousStep, {"fixedColumnA", "fixdColumnB"}, "Attribute", "Value")
Pete
Proud to be a Datanaut!
Something like:
= Table.Unpivot(#"Filtered Rows1", List.RemoveFirstN(Table.ColumnNames(#"Filtered Rows1"),3), "Attribute", "Value")
Covering 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.