We're excited to announce that we have DAX legend Marco Russo presenting at October's Power BI and Fabric User Group meetup in October.

Accounts receivable aging with modelling patterns in Power BI

Most specific business scenarios can be solved by applying modeling patterns in Power BI. Instead of creating custom calculations with the source data model – which could not be optimized for DAX measures – we can apply a transformation to the data model to use a standard data modeling pattern.

For example, the accounts receivable aging report can be solved by applying two patterns: “Events in progress” and “dynamic segmentation”. In case of performance issues, adding a snapshot also improves performance.

In this session, we analyze an initial data model that does not match existing patterns. However, associating a problem with existing and well-known data modeling patterns can save design and implementation time: do not reinvent the wheel if someone already did it before you! We will go through the implementation steps, explaining the data model and DAX formulas obtained by applying common patterns.

About Marco

Marco is a business intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly write articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services.

Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences. He also enjoys delivering evening sessions at local user groups during his trips.

Agenda: 18:30 : Welcome, pizza and drinks 19:00 - 20:00 : Main Session

Big thanks again to the London Data School for hosting us in their amazing venue in the heart of London, close to St Paul's Cathedral:

The Data School / The Information Lab, Floor 1, 25 Watling Street, EC4M 9BR