Sacramento SQL Server User Group

Attending PASS Summit 2019? Use discount code LGDIS6HUR to save $150 and support our group!


Next Meeting




Intro to DAX in the Tabular Data Model - Christian Chanco

  • Harvard Square (map)
  • 2180 Harvard Street, Suite 280 (Second Floor)
  • Sacramento, CA 95815
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Intro to DAX in the Tabular Data Model - Christian Chanco

RSVP on Meetup:

DAX, measures, and you: How to use DAX to query your tabular data model.

Have you implemented Power BI in your work to build powerful dashboards and want to encapsulate complex business logic? Do you struggle writing MDX queries in the multidimensional model? If your answer is yes, then join me in this DAX presentation to see how to create measures that make use of the DAX language. I will go over the DAX (Data Expression Language), powerful functions such as SUMMARIZECOLUMNS(), HASONFILTER(), CALCULATE(), USERELATIONSHIP(), RELATED(), FILTER(), ALL() and many more. I will go over the use of variables to make your DAX expression self-documenting and create additional columns in the dimension Date table that slicers or parameters can use to detect the years/months with actual data in Fact Tables.

About the Presenter:
Christian Chanco is a Business Intelligence Developer at Dignity Health Medical Foundation (now part of Common Spirit Health) and promotes the use of Microsoft business intelligence products to find robust business solutions. Lately, he replaced manually ETL processes and reports and automated them with Power BI and DAX for Dignity Health Medical groups in the California Market.

Meeting Sponsor:

Sacramento SQL Server User Group:

Upcoming Events:

SQLSaturday Sacramento 2019:
Join us Saturday, August 17, for a full day of free and fun-packed SQL Server training!

[SQLSatSac PreCon] Brent Ozar: "Performance Tuning in 21 Demos"
A full day of training on Friday, August 16 with Brent for just $199!

[SQLSatSac PreCon] Kalen Delaney: "SQL Server Query Plans: Reuse or Recompile"
A full day of training on Friday, August 16 with Kalen for just $199!

PASS Summit 2019 Discount Code: LGDIS6HUR
Attending PASS Summit 2019 in Seattle this November? Use discount code LGDIS6HUR to save $150 and support the Sacramento SQL Server User Group when you register for the Full 3-Day PASS Summit!

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors



Back to Top