Creating a summary table out of existing table - assistance

[rashel2002]

Hi everyone!

I have a table as the one on the left and i want to sum up the effort per week (creat a new table as the one on the right)-

Any ideas how to do it?

Thx.

[Greg_Deckler · Accepted solution]

Use the oddly named function "SUMMARIZE":

Table = SUMMARIZE('Table',[Week No.],"Effort (by hours)",SUM([Effort (by hours)])

😉 

[Anonymous]

I have a similar issue but I'd like to bring all the rest of the columns from my original table into the summarized table.  I see that I can list them individually.  Is there a command that will bring them all?

[rashel2002]

Hi again!

there is an oprion to summerize by two categories?

For example, by WW and by Type (imagine there is another column named Type and describing for each line if it's type a or type b).

[rashel2002]

Nevermind, i figured it out! thanks again!! 🙂

[Anonymous]

How did you do that? As i would like to sumarise based on two colomns. 

Original Data
Order	Suf	Amount
500	0	200
500	1	150
500	1	200
500	2	300
501	0	400
502	0	300
502	0	200
502	1	400
502	1	300
502	2	100
503	3	100

Option 1
Order	Amount	Suf	Amount
500	850	0	200
500		1	350
500		2	300
501	400	0	400
502	1400	0	500
502		1	700
502		2	100
502		3	100

Option 2 - Prefered
Order	Total	Suf	Amount	Suf	Amount	Suf	Amount	Suf	Amount
500	850	0	200	1	350	2	300
501	400	0	400
502	1400	0	500	1	700	2	100	3	100

[rashel2002]

Hi Greg!

Thank you for responding 🙂

i'm new at PBI and don't have much experience so it might be a weird question but -

where should i insert the line you wrote? 

[JWorthy]

I had this same question.

It's under the 'Modeling' tab, 'New Table'

I followed the instructions here:

https://radacad.com/creating-a-table-in-power-bi-using-dax-table-constructor