The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |