Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Wed, Aug 14 2019

Using calculation groups in DAX

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Perth-Microsoft-Data-And-Analytics-User-Group/events/263137874

Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the year-over-year calculation once and apply it to all the measures you want. Yet, calculation groups can do more than that.

This session introduces the syntax of calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.

When

iCal
UTC : Wed, Aug 14 2019 09:30 - 11:00
Event Time : Wed, Aug 14 2019 17:30 - 19:00 (UTC+08:00) Perth
Your Local Time: Wed, Aug 14 2019 09:30 - 11:00

Where

Level 10, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

Using calculation groups in DAX

Speaker: Marco Russo, Business Intelligence consultant and mentor SQLBI

Summary: Calculation groups are the most important feature introduced in DAX after variables in 2015. By using calculation groups, you can apply transformations to existing measures without having to create new measures in the model. For example, you can define the year-over-year calculation once and apply it to all the measures you want. Yet, calculation groups can do more than that. This session introduces the syntax of calculation groups, when they should be used and several examples of use cases. You will also learn how calculation groups work internally and what are the limits of this amazing tool.

About Marco: Marco Russo is a Business Intelligence consultant and mentor, specialized in Microsoft BI Technologies. He wrote several books about DAX, Analysis Services, Power BI, and Power Pivot, and regularly publish articles and tools on www.sqlbi.com. He is also a speaker at international conferences such as Microsoft Ignite, PASS Summit, and SQLBits.

Attachments

Supplementary Materials

The following event attachments are available to you:

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids