New table with sum of other colums out of other table

[0xygen27]

Dear Community,

I have two tables in my document. 1 table is the cost of projects, the other is budget for those projects. I want to make two other tables with the sums of different colums that for a project.

For example 

I got these colums:

Expense A : 5

Expense B : 10

Expense C:  7

Now Expense A and C form Project A. So I want a table with all the sums of the projects. 

----------------------------------------------------------------------------------------------------------

Later on I want to make a graph with Project A cost 12 in which I can go to a lower level and then the graph shows me:

Expense A 5 

Expense C 7 

Is this possible?

 

[v-caliao-msft]

@0xygen27,

Yes. You could do this. To create such a table, you need to have a Project column in your original table to identify which Project is current expense belong to.

Cretae a new table use the DAX expression below
Table = FILTER(Table1,Table1[Project]="A")

Regards,

Charlie Liao

[0xygen27]

@v-caliao-msft I got like 200 expense columns. I don't got one column with the name expenses. 

So: 

Dates | Expense A | Expense B | Expense C

[v-caliao-msft]

@0xygen27,

If that is the case, I am afraid you need to reshare you source table.

Regards,

Charlie Liao