Summarize a table by rows from multiple columns

[aridavid]

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!

[ryan_mayu]

@aridavid 

pls see the attachment below

[aridavid]

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'.

[ryan_mayu · Accepted solution]

@aridavid 

i imported the data as you shared and did data transform in the PQ editor.

you can check the source and followed the steps I did.