Forum Discussion
Add All Columns Except One
Since new columns will be added all the time, you don't have a true table, but a Pivoted data set. Start by UnPiviotOtherColumns. This will take ALL Other Columns but the one(s) specified and convert them into 'Attribute' (Column Name) and 'Value' (Number Value previously in each column).
Once done, you can create a simple Table of 'Name' and SUM 'Value' to sum ALL columns other than Name even if the raw input changes. *** I couldn't get this working testing with .csv files, but I think that was because of 'type' of the new columns wasn't being defined. I hope with your real data source you might have better luck... ***
= Table.UnpivotOtherColumns(#"Changed Type", {" Name"}, "Attribute", "Value")
Hey thanks for the prompt reply, The column values were just examples, the numbers are more complex than the example. The problem I am having is the number of extra columns is not specified because the client is inputting values into our CRM.
Super UserOk, but we can't help if we don't see an example to suggest a function or measure. Can you add a sample of the data so we can understand the logic involved?