Forum Discussion
Custom M Script to sum values from Joined/Merged Queries
Hi guys heres what i'm trying to accomplish.... My data structure Table1: ID#| Capability.1 | Capability.2 | Capability.3| .... 37 total Capability.# columns
97 | Crawl | Walk |...
MarkDGaal Are you after solution in R ?
Hi ankitpatria, thank you, but I found my solution through a combination of unpivoting, grouping, otherwise transforming, and re-merging my quieres in the query editor.
