Supercharge Power BI

Power BI is Better When You Learn To Write DAX

MrExcel's Holy Macro! Books, Matt Allington

• Publisher: De Gruyter
• Year: 2025
• eBook ISBN:
  9781836643029
• Topic: Computer Science
• Index: Computer Science

No detailed description available for "Supercharge Power BI".

Table of contents

• Here’s How: Getting Power BI Desktop
• Here’s How: Loading Data from a New Source
• Here’s How: Creating Relationships in Power BI Desktop
• Here’s How: Making Changes to a Table That Is Already Loaded
• Here’s How: Deleting Steps in a Query
• Here’s How: Importing New Tables
• Here’s How: Changing the File Location of an Existing Connection
• Here’s How: Inserting a Matrix
• Here’s How: Writing Measures
• Here’s How: Increasing the Matrix Font Size
• Here’s How: Using IntelliSense
• Here’s How: Editing Measures
• Here’s How: Adding Comments to Measures
• Here’s How: Creating New Pages in Power BI
• Here’s How: Changing Display Names in Visuals
• Here’s How: Word Wrapping in a Visual
• Here’s How: Applying Conditional Formatting
• Here’s How: Drilling Through Rows in a Matrix
• Here’s How: Moving an Existing Measure to a Different Home Table
• Here’s How: Moving All Measures to a New Table
• Here’s How: A Basic (but Wrong!) Calculated Column
• Here’s How: Creating a Day Type Calculated Column
• Here’s How: Changing the Month Name Sort Order
• Here’s How: Using ALLEXCEPT()
• Here’s How: Turning Off Auto Date/Time
• Here’s How: Using SAMEPERIODLASTYEAR()
• Here’s How: Changing Summarization for Multiple Columns at Once
• Here’s How: Manually Adding Data to Power BI
• Here’s How: Using What-If
• Here’s How: Solving Practice Exercise 70
• Here’s How: Creating a Morphing Switch Measure
• Here’s How: Applying Banding
• Here’s How: Editing a Table Previously Created with the Enter Data Feature
• Here’s How: Deleting Interim Calculated Columns
• Here’s How: Bridging a Budget Table
• Here’s How: Enabling Bidirectional Cross-Filtering
• Here’s How: Publishing a Report to PowerBI.com
• Here’s How: Installing Analyze in Excel
• Here’s How: Using Analyze in Excel
• Here’s How: Converting a Pivot Table to Cube Formulas
• Here’s How: Writing CUBEVALUE() from Scratch
• Here’s How: Applying Filters to Cube Formulas
• Here’s How: Adding a Slicer Without a Pivot Table
• Here’s How: Connecting a Slicer to a Cube Formula
• Here’s How: Importing Excel Power Pivot Workbooks to Power BI Desktop
• Here’s How: Writing Measures
• Introduction
• 1: Concept: Introduction to Data Modelling
• 2: Concept: Loading Data
• 3: Concept: Measures
• 4: DAX Topic: SUM(), COUNT(), COUNTROWS(), MIN(), MAX(), COUNTBLANK(), and DIVIDE()
• 5: Concept: Filter Propagation
• 6: Concept: Lookup Tables and Data Tables
• 7: DAX Topic: Calculated Columns
• 8: DAX Topic: The Basic Iterators SUMX() and AVERAGEX()
• 9: DAX Topic: CALCULATE()
• 10: DAX Topic: Making DAX Easy to Read
• 11: Concept: Evaluation Context and Context Transition
• 12: DAX Topic: IF(), SWITCH(), and FIND()
• 13: DAX Topic: VALUES(), HASONEVALUE(), SELECTEDVALUE(), and CONCATENATEX()
• 14: DAX Topic: ALL(), REMOVEFILTERS(), ALLEXCEPT(), and ALLSELECTED()
• 15: DAX Topic: FILTER()
• 16: DAX Topic: Time Intelligence
• 17: DAX Topic: Variables in DAX
• 18: DAX Topic: RANKX() and TOPN()
• 19: DAX Topic: RELATED() and RELATEDTABLE()
• 20: Concept: Disconnected Tables
• 21: Concept: Multiple Data Tables
• 22: Concept: Using Analyze in Excel and Cube Formulas
• 23: Concept: Transferring DAX Skills to Excel
• 24: Concept: Next Steps on Your DAX Journey
• Appendix A: Answers to Practice Exercises
• Appendix B - DAX Quick Reference List
• Table of Here's How Sections
• Index
• Blank Page