Pro DAX and data modeling in Power BI creating the perfect semantic layer to drive your dashboard analytics
Develop powerful data models that bind data from disparate sources into a coherent whole. Then extend your data models using DAX–the query language that underpins Power BI–to create reusable measures to deliver finely-crafted custom calculations in your dashboards. This book starts off teaching you...
Main Author: | |
---|---|
Format: | eBook |
Language: | English |
Published: |
New York, NY
Apress
2022
|
Edition: | [First edition] |
Subjects: | |
Online Access: | |
Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- 1. Using Power BI Desktop to Create a Data Model
- 2. Extending The Data Model
- 3. The Semantic Layer
- 4. Calculated Columns
- 5. Calculating Across Tables
- 6. DAX Logical Functions
- 7. Date and Time Calculations in Columns
- 8. Introduction to Measures
- 9. Filtering Measures
- 10. CALCULATE() Modifiers
- 11. The Filter() Function
- 12. Iterators
- 13. Creating and Applying a Date Dimension
- 14. Time Intelligence
- 15. DAX Variables
- 16. Table Functions
- 17. Extending the Data Model
- 18. Evaluation Context
- Appendix A: Sample Data