Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |