Forum Discussion
Solved
Summarize a table by rows from multiple columns
Hello,
I have the following use case, where a table contains:
Table_Savings
| Product1_LongTerm | Product1_ShortTerm | Product2_LongTerm | Product2_ShortTerm | Product3_LongTerm | Product3_ShortTerm |
| 500 | 50 | 200 | 20 | 600 | 60 |
| 100 | 10 | 100 | 10 | 400 | 40 |
| 600 | 60 | 700 | 70 | 800 | 80 |
And I'd like to create a table that summarizes totals by the Product of each column, like this:
New_Table
| Product | LongTerm | ShortTerm |
| Product1 | 1200 | 120 |
| Product2 | 1000 | 100 |
| Product3 | 1800 | 180 |
Would it be possible to create something like this in DAX or any other method?
Thanks a lot!
3 Replies
Thanks ryan_mayu this is helpful, the problem I have is that my data is not tabulated as per te attributes column you shared. I have em' in separate columns, the tricky part is to actually get to have them in the way you plot them, like all in one single column.
I was thinking maybe transforming the table at a query level would be 'easier'.
