Model | BI & Reporting
Level: Yes - A
Presentation Type: Presentation
Most Microsoft BI developers are familiar with authoring DAX measures for Analysis Services Tabular models and Power BI datasets. However, far fewer are experienced with writing DAX queries or integrating DAX queries into MSBI projects. This session includes three 20 minute segments as follows: DAX query structure and functions; embedding DAX queries into DAX measures; and leveraging DAX queries in paginated Power BI Report Server reports. Attendees will learn the essential concepts and functions of DAX as a query language, powerful DAX features including variables and set-based functions, and how to utilize DAX Studio to develop and test DAX queries. Each segment of this session will be supported by multiple example DAX queries and all queries will be made available for download following the event.