title


counters

Monday, 10 March 2014

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.

No comments:

Post a Comment