Intro to DAX in the Tabular Data Model - Christian Chanco
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.
Sacramento SQL Server User Group:
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!