Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
0xygen27
Advocate II
Advocate II

New table with sum of other colums out of other table

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?

 Sum project.png

 

3 REPLIES 3
v-caliao-msft
Employee
Employee

@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")
Capture.PNGCapture1.PNG

 

Regards,

Charlie Liao

@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

@0xygen27,

 

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

 

Regards,

Charlie Liao

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.