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.

Auckland Fabric, Power BI and Analytics

leila

David Horrocks

Indira Bandari

Reza Rad

Fowmy Abdulmuttalib

Angela Kephart

Mui Boon Loong

Aush

Shanob Kottal

Beni Oktopiansah

Ciprian-Flavius Hancu

Jaydip Kadam

Graham Barker

Kevin Arguedas

abdurrahmanolaniyan01

Justin Kim

Nikeeta Kumari 

Tharaneetharan Thavarasan

Afshin Dejbodi

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

Online event

AnalyticsNetwork

Search {networkName}

Groups

{PRO_NETWORK_NAME} is on Meetup Pro with more than {PRO_MEMBER_COUNT} members across {PRO_GROUP_COUNT} Meetups worldwide. Meetup Pro is the professional tool for organizing and communicating a network of users, partners, contributors and members.

AnalyticsNetwork

AnalyticsNetwork

Who we are

Search AnalyticsNetwork

Upcoming events

Groups