O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summarizing with Group By

When creating visualizations in Power BI, data can be aggregated (summarized, counted, averaged, and more). There are circumstances where the data needs to be aggregated prior to being used on visualizations, perhaps so it can be merged or appended to another query. When this circumstance arises, we can use the Power BI Group By feature in the Query Editor. Let's do that now by creating a list where each vendor is listed once, along with the total amount due and the number of invoices that are outstanding:

  1. As we've used the AP Document Details query for visualization, we do not want to aggregate that query. Instead, we'll duplicate the AP Document Detail query and use the duplicate. In the Queries pane on the left (sometimes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required