Index
removing fields, 671
reverse, 698
summary techinques, 669–670
terminology, 666–667
plot area, 450, 451
modifying, 496–497
pmt argument, PV function, 355
PMT function, 345–346
portrait mode, printing in, 181
Power Pivot
calculated measures
creating, 830–832
deleting, 832–833
editing, 832
overview, 829–830
compatibility, 784–785
data model
adding tables, 787–788
feeding, 807–813
loading data from flat files, 798–802
managing relationships, 813–814
preparing tables, 786
referencing fields from other tables, 827–829
refreshing, 803–804
removing tables, 814–815
using Cube functions in, 833–834
DAX (Data Analysis Expression) functions
building DAX-driven calculated columns, 824–827
identifying for calculated columns, 1424
nesting, 829
referencing fields from other tables, 827–829
editing data connections, 805
linking Excel tables, 785–792
loading data
from flat files, 798–802
from relational databases, 793–798
Manage, 793
refreshing data, 803–804
Ribbon interface, activating, 783–784
Power Query
aggregating data, 884–886
appending data, 891–895
blank fields, filling in, 862
columns
column-level actions, 846–849
concatenating, 863–865
creating custom columns, 877–884
pivoting, 875–877
selecting, 906
splitting, 870–873
unpivoting, 873–875
copying queries, 908
data sources, selecting, 836–837
duplicate records, removing, 859–861
empty strings, filling in, 862–863
getting query information, 903–904
grouping data, 884–885
importing data, 851–852
from database systems, 855
from files, 852–854
from other data systems, 855–856
M language, 842–844
managing data source settings, 856–858
managing queries, 845–846
merging queries, 896–901
organizing queries, 904–905
performance issues, 910–913
preventing automatic data type changes, 909–910
productivity tips, 903–910
query steps, 842–843
managing, 843
renaming, 906–907
reusing, 887–890
viewing, 842
refreshing data, 844
sample query, 835–842
saving queries, 841
setting default load behavior, 908–909
table-level actions, 849–851
text
changing case, 865
cleaning and trimming, 866–868
extracting first and last characters, 869–870
extracting left, right, middle values, 868–869
extracting middle characters, 870
finding and replacing, 865–866
Power Query Editor, 908–912
column-level actions, 838–839, 846–849
M code, viewing and editing, 844
query steps, viewing, 842
table-level actions, 840, 849–851
precedents, selecting, 78
Precedents option, Go To Special dialog box, 78
Print Preview, 174
printers
choosing, 180
page setup settings, 178–180PivotTables (cont inued)