Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have a table to followup project's costs, with one line per Purchase order /invoice, having one column as well for the budget. I would like to have a summary table with one line per project summarizing all numbers, as here below:
I think it is self explanatory but just in case:
Thanks!!
Jose
Solved! Go to Solution.
Hi @Palace27 ,
You can create a "Reference" to this table in Power Query in order to create the new one. After that, you can use the "Group By" option to group your data by "Project Id" with the desired aggregation function for each column. Please check screenshots below:
After creating the Reference, delete the columns that are not value and will not be used for the grouping (PO Number, for instance), and then select Group By:
Select a aggregation function for each column with values:
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Hi,
it looks like you could use a series of measures:
Hello @Syndicate_Admin you can create a dimension called "Projects" and connect it to your summary table, then you can create metrics that solve your problem
I leave here the PBI file,
example.pbix
If my answer seems valid, consider marking it as a solution 🙂.
Hi,
it looks like you could use a series of measures:
Hi @Palace27 ,
You can create a "Reference" to this table in Power Query in order to create the new one. After that, you can use the "Group By" option to group your data by "Project Id" with the desired aggregation function for each column. Please check screenshots below:
After creating the Reference, delete the columns that are not value and will not be used for the grouping (PO Number, for instance), and then select Group By:
Select a aggregation function for each column with values:
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
63 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |