Houston Area SQL Server User Group

HASSUG and Houston BI User Group normally meets on the second Tuesday of every month during lunch time.   Occasionally, we will meet at other time, so please watch this page for updates. 


10111 Richmond Ave
Houston, Texas 77042

Next Meeting: Wed, Apr 05 2017

HASSUG April Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://meetu.ps/38lQrr

Meeting Agenda:

6:00 – 6:20 – Networking & Pizza
6:20 – 6:25 – Announcements
6:25 –  7:30 – Time Intelligence in DAX By Marco Russo

Note: We had the opportunity for Marco to speak to us while he is in town, so we hope you can take advantage of it!


UTC : Wed, Apr 05 2017 23:00 - 00:30
Event Time : Wed, Apr 05 2017 18:00 - 19:30 Central Daylight Time
Your Local Time: Wed, Apr 05 2017 23:00 - 00:30


10111 Richmond Ave
Houston, Texas

Direction: We will be meeting on the first floor in Suite 170.

Featured Presentation

Time Intelligence in DAX

Speaker: Marco Russo, Consultant SQLBI

Summary: Time Intelligence is probably the most interesting feature of any analytical solution. Computing Year-To-Date, Month-To-Date, Same-Period-Last-Year, is quite easy in DAX but, as soon as the customer requests for time intelligence require working days’ evaluation, complex and custom calendar shapes, seasonal pattern recognition, the DAX formulas start to be harder to write. In this session, we are going to show how to compute classical time intelligence with the built-in DAX functions. Then, we will show some more complex time intelligence formulas, which require thinking out of the box, using advanced data modeling and querying techniques to produce interesting and useful formulas.

About Marco: Marco is a Business Intelligence consultant and mentor. He worked with Analysis Services since 1999, and wrote several books about Power Pivot, Power BI, Analysis Services Tabular, and the DAX language. With Alberto Ferrari, he writes the content published on www.sqlbi.com, mentoring companies’ users about the new Microsoft BI technologies. Marco is also a speaker at international conferences such as Microsoft Data Insights, PASS Summit, Microsoft Ignite, and SQLBits.



Global PASS Sponsors:




Local Group (HASSUG) Sponsors:



Back to Top