更新时间：2021-07-02 15:03:22
coverpage
Title Page
Copyright
Microsoft Power BI Complete Reference
About Packt
Why subscribe?
PacktPub.com
Contributors
About the authors
About the reviewers
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Conventions used
Get in touch
Reviews
Getting Started with Importing Data Options
Getting started
Importing data
Excel as a source
SQL Server as a source
Web as a source
DirectQuery
Limitations
Live Connection
Which should I choose?
Summary
Data Transformation Strategies
The Power Query Editor
Transform basics
Use First Row as Headers
Remove Columns
Change type
Add Column From Examples
Advanced data transformation options
Conditional Columns
Fill Down
Unpivot
Merging Queries
Appending Queries
Leveraging R
Installation and configuration
The R Script transform
M formula language
#shared
Building the Data Model
Building relationships
Editing relationships
Creating a new relationship
Working with complex relationships
Many-to-many relationships
Cross-filtering direction
Enabling filtering from the many side of a relationship
Role-playing tables
Importing the date table
Usability enhancements
Hiding tables and columns
Renaming tables and columns
Default summarization
How to display one column but sort by another
Data categorization
Creating hierarchies
Leveraging DAX
Building calculated columns
String functions – Month Year
Format function – Month Year
Age calculation
SWITCH() – age breakdown
Navigation functions – RELATED
Calculated measures – the basics
Calculated measure – basic aggregations
Total Sales
Total Cost
Profit
Profit Margin
Optional parameters
Filter context
Calculate
Percentage of total calculation
Time intelligence
Year to Date Sales
YTD Sales (Fiscal Calendar)
Prior Year Sales
Visualizing Data
Data visualization basics
Visuals for filtering
Interactive filtering
The Slicer visual
Visualizing tabular data
The table visual
The Matrix visual
Visualizing categorical data
Bar and Column charts
