Function
Find, Filter and Sort
|
|
Find
|
Description
FIND and FINDB locate one text string within a second text string
and returns the number of starting positions for the first text string from
the first character of the second text string.
FIND KEY is for use with languages that use single-byte character set (SBCs), while
FINDB is for use with languages that use double-byte character set
(DBCS). The default language setting on your computer affects the return in
the following ways:
FIND always count each character, whether single-byte or
double-byte, as 1 regardless of the default language setting used.
FINDB count each double-byte character as 2 when you have enabled
editing language that supports DBCS and then set it as the default language.
If not, FINDB count each character as 1.
|
Filter
|
Restoring tables represent a subset of a table or other expressions.
This article describes a function in Data Analysis Expressions
(DAX), a formula expression language used to define calculations in Power
Pivot in Excel. Most DAX functions with the same name and similar behavior as
Excel functions; however, DAX functions can only be used in DAX formula.
|
Sort
|
Sorting data in alphabetical order or from highest to lowest values
(or vice versa) is helpful when you have large amounts of data in the
PivotTable you created. Sorting lets you organize the data so it’s easier to
find the items you want to analyze.
|
Monday, 10 March 2014
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment