question

RichardRisinger-7492 avatar image
0 Votes"
RichardRisinger-7492 asked ·

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

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-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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--




·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.