Langbeschreibung
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.
Hauptbeschreibung
Shows how to build powerful data models from disparate data sources
Inhaltsverzeichnis
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.