Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
@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
If that is the case, I am afraid you need to reshare you source table.
Regards,
Charlie Liao
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |