Developing report

[Pbilearner02]

Hi all,

I am a new bee to Power BI and trying to learn while trying to do a report. I have a report as table1.  I had clean the data like two sep table - table 2 and 3.  Finally append them as Table 4.  But now I need the subtotal per week ending

Table 1:

Name

Title

Manager

Pillar

Week ending

Adminstrative

Admin sub category

Ad Mon

Ad Tue

Ad Wed

Ad Thur

Ad Fri

DP support

DP support sub category

DP Mon

Dp Tue

Dp Wed

Dp Thur

DP Fri

AAAA

DBA

ljdlsjd

xyz

11/11/2022

administrative

meeting

1

2

1

DP support

training

4

2

1

1.5

AAAA

DBA

ljdlsjd

xyz

11/8/2022

administrative

filing

0.5

1

1.5

0

DP support

training

2.5

2

1

Table 2:

Name

Title

Manager

Pillar

Week ending

Category

sub category

Mon

Tue

Wed

Thur

Fri

AAAA

DBA

ljdlsjd

xyz

11/11/2022

administrative

meeting

1

2

1

AAAA

DBA

ljdlsjd

xyz

11/8/2022

administrative

filing

0.5

1

1.5

0

Table 3:

Name

Title

Manager

Pillar

Week ending

Category

sub category

Mon

Tue

Wed

Thur

Fri

AAAA

DBA

ljdlsjd

xyz

11/11/2022

DP support

training

4

2

1

1.5

AAAA

DBA

ljdlsjd

xyz

11/8/2022

DP support

training

2.5

2

1

Table 4:

Name

Title

Manager

Pillar

Week ending

Category

sub category

Mon

Tue

Wed

Thur

Fri

AAAA

DBA

ljdlsjd

xyz

11/11/2022

administrative

meeting

1

2

1

AAAA

DBA

ljdlsjd

xyz

11/8/2022

administrative

filing

0.5

1

1.5

0

AAAA

DBA

ljdlsjd

xyz

11/11/2022

DP support

training

4

2

1

1.5

AAAA

DBA

ljdlsjd

xyz

11/8/2022

DP support

training

2.5

2

1

[serpiva64]

Hi,

to do what you want you need to create a new column by selecting your column and adding them 

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Pbilearner02]

Hi Serpiva

can I do it according to the week ending?  If I am collaborating it,  in report developer how can I do total hours per week.

thank you serpiva for all the help.

[serpiva64]

Hi,

can you post an exemple of your desired result

[Pbilearner02]

Hi 

Here is what I want to look the data as :

Name

Title

Manager

Pillar

Week ending

Category

sub category

Mon

Tue

Wed

Thur

Fri

Total hours

AAAA

DBA

ljdlsjd

xyz

11/11/2022

administrative

meeting

1

2

1

4

AAAA

DBA

ljdlsjd

xyz

11/8/2022

administrative

filing

0.5

1

1.5

0

3

AAAA

DBA

ljdlsjd

xyz

11/11/2022

DP support

training

4

2

1

1.5

8.5

AAAA

DBA

ljdlsjd

xyz

11/8/2022

DP support

training

2.5

2

1

5.5

[v-xiaotang · Accepted solution]

Hi @Pbilearner02 

please try this, select the columns then click Standard - Add

result

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.