Forum Discussion
Power BI Desktop Sum By Group
Hi Power Geeks, I am looking for Grouping by SUM, And Sum for each dynamic group (Store ID),similar to SSRS or Crystal Reports. Currently the Report looks like: INVOICE PRICE Store ...
Hi,
I cannot get your desired result using Power BI desktop. Using Excel, i can get a close enough result (see screenshot). In Excel, i have used Power Query (the Index column has been generated using Power Query) and Pivot Tables to get your desired result.