This is for business intelligence developers new to DAX formulas.
If you are planning on working with Power BI, PowerPivot, or SSAS Tabular, you are going to need to learn DAX. DAX looks like some frankenstein child of Excel formulas and SQL. Unfortunately this can lull new developers into a false sense of confidence. The truth is that DAX is a whole new beast, requiring whole new mental models and concepts. This talk focuses on those core concepts.
Specifically, we are going to cover how to add business logic via calculated columns and measures. Then we are going to cover the two things DAX is great at: aggregations and filtering. Finally, we are going to look at iterators and some more advanced filter manipulation.
Why I Want to Present This Session:
If I had a time machine, I would travel back in time two years and show this presentation to myself. As a result, I would have saved myself hours of grief trying to understand DAX.
Since I can’t do that, I’m going to travel forward in time and present this to people who are not me and save them hours of grief instead.
Latest posts by Eugene Meidinger (see all)
- SQL Server Health Checks - July 30, 2017
- Just Enough Database Theory for Power BI - June 15, 2017
- Keeping up with Technology: Drinking from the Firehose - June 2, 2017