How can I create an aggregated query in Power BI from an existing query

Richard Risinger 1 Reputation point
2021-03-12T16:33:59.893+00:00

I have a query in Power BI Desktop which is built from an Excel worksheet. The worksheet is updated daily with open order lines (items, quantities, $$ values, customer details). Each row in the query refers to a single order line item. So, a given order will have multiple rows in the query. Details for a single customer may include multiple orders, each of which contain multiple items.

So, the data is item-level.

I want to create a summarized version of the query at the order-level, aggregating total units, total $ and count of items so that the resulting query includes one row per order.

I am very new to Power BI, but have a fair working knowledge of how I would perform this in Tableau, if that helps drive an answer to my dilemma.

Any help would be greatly appreciated

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,738 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2021-03-12T16:37:55.92+00:00

    Power Bi is not currently supported here on QnA. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments No comments