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.
Table transformation... the top three rows are how the data appears, I want the data to look like it does below in one row... i assume this is possible, any ideas and help? Thank you so much.
Rank | Name | Rating | Number of ratings | ||
1 | Kentucky Brunch Brand Stout | 4.84 | 615 | ||
1 | Toppling Goliath Brewing Company | 4.84 | 615 | ||
1 | American Double / Imperial Stout / 12.00% ABV | 4.84 | 615 | ||
Rank | Name | Name 2 | Name 3 | Rating | Number of ratings |
1 | Kentucky Brunch Brand Stout | Toppling Goliath Brewing Company | American Double / Imperial Stout / 12.00% ABV | 4.84 | 615 |
Solved! Go to Solution.
Indeed, a little bit from both because this includes some logic I recntly learned from @ImkeF
let Source = Table1, Grouped = Table.Group(Source, {"Rank", "Rating", "Number of ratings"}, {{"Names", each Table.FromRows({[Name]}), type table}}), Reordered = Table.ReorderColumns(Grouped,{"Rank", "Names", "Rating", "Number of ratings"}), ExpandedNames = Table.ExpandTableColumn(Reordered, "Names", Table.ColumnNames(Table.Combine(Reordered[Names]))), RenamedColumns = Table.TransformColumnNames(ExpandedNames, each Replacer.ReplaceText(_, "Column", "Name ")) in RenamedColumns
That's a question for @MarcelBeug or @ImkeF.
Indeed, a little bit from both because this includes some logic I recntly learned from @ImkeF
let Source = Table1, Grouped = Table.Group(Source, {"Rank", "Rating", "Number of ratings"}, {{"Names", each Table.FromRows({[Name]}), type table}}), Reordered = Table.ReorderColumns(Grouped,{"Rank", "Names", "Rating", "Number of ratings"}), ExpandedNames = Table.ExpandTableColumn(Reordered, "Names", Table.ColumnNames(Table.Combine(Reordered[Names]))), RenamedColumns = Table.TransformColumnNames(ExpandedNames, each Replacer.ReplaceText(_, "Column", "Name ")) in RenamedColumns
wow, that is awesome!! It worked brilliantly.
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.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |