Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone...
I want to summarize the Capex numbers in the below table, by Project ID, so I can then delete the "Month" column and then have only 1 row per Project ID. Does anyone know if this is possible in Query Editor? If so, what are the steps?
Thanks in advance to anyone who can assist.
Solved! Go to Solution.
@bchager6 You can use the Group By operation in Power Query Editor.
In DAX it is SUMMARIZE and GROUPBY
Hi @bchager6 ,
@Greg_Deckler is right. You could try “Group By”. Please take a look at the blog to have a try.
Grouping rows with Power BI / Power Query
@bchager6 You can use the Group By operation in Power Query Editor.
In DAX it is SUMMARIZE and GROUPBY
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |