Name: Online Only: Exploring window functions and visual calculations by Owen Auger
Start: 2025-09-24T12:00:00+12:00
End: 2025-09-24T13:00:00+12:00

We will have this meeting **online-only** through Microsoft Teams.
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

### Exploring window functions and visual calculations

The first DAX window functions (INDEX, OFFSET, and WINDOW) were introduced in December 2022, soon followed by RANK and ROWNUMBER. Visual calculations were introduced in February 2024. Both of these features are still in preview, but provide a rich set of features to learn and explore. In this session, I will demonstrate how both features can simplify DAX expressions, avoid clutter in your Power BI semantic models, and make your reports more flexible.

I will cover examples including:
Using window functions to:
o Perform calculations “per partition”, such as top customer per group.
o Simplify rank calculations compared with RANKX.
o Calculate ranks based on multiple columns.
o
Using visual calculations to:
o Perform calculations that work with any date field placed on a visual’s axis.
o Filling blanks with zeros (or any other value).
o Identify top/bottom values.
o Normalize measure values.
o Navigate a visual’s hierarchy.
I will provide a demonstration PBIX for you to take away and adapt to your own reporting needs.
If you want to extend your DAX knowledge, simplify your Power BI semantic models, and add some exciting and flexible tools to your Power BI arsenal, then this session is for you!

**Speaker: Owen Auger**
Principal Consultant, Agile Analytics
Owen Auger specialises in data modelling and visualization with Power BI, as well as financial modelling. He is currently a Principal Consultant at Agile Insights and has worked previously in analytics and finance roles at Fonterra and Contact Energy. He was a finalist at the 2014 Financial Modelling World Championships in New York City. He has a particular interest in using Power BI and related tools to improve efficiency of reporting and analysis among finance business users. Owen is a CFA Charterholder and has a Master of Operations Research.

**Meetup Sponsor:**

\*\*[RADACAD ](https://radacad.com/)\*\*is a leading Power BI and Microsoft Fabric training and consulting firm and a Microsoft Gold Partner in Data Analytics. We provide training to upskill, consultation to enhance, and expert development support for Data analytics projects using Microsoft Fabric and Power BI.

We will have this meeting through Microsoft Teams online-only. Do NOT come to the Microsoft Office, no one will be there. See you online.

leila

David Horrocks

Reza Rad

Indira Bandari

Auckland Fabric, Power BI and Analytics

AnalyticsNetwork

Microsoft New Zealand hosts and provides high quality venue for events.

Microsoft New Zealand

RADACAD sponsors our events with hosting and catering.

RADACAD

Technology

Data Visualization

Power BI

Business Intelligence

Business Intelligence & Data Warehousing

Data Analytics

Business Intelligence in Cloud

Business Analytics

SQL Integration Services

SQL Server

Business Intelligence Tools

Machine Learning

Agile Data Warehousing

Online Only: Exploring window functions and visual calculations by Owen Auger

Online event

Share

Auckland Fabric, Power BI and Analytics

Online Only: Exploring window functions and visual calculations by Owen Auger

Auckland Fabric, Power BI and Analytics

Details

Sponsors

Members are also interested in