文件名称:
Power+Query+函数库+(February+2015+含标签).pdf
开发工具:
文件大小: 3mb
下载次数: 0
上传时间: 2019-07-07
详细说明:包含部分自学时的笔记;适合初学者参考4.2 Date ToText
50
4.3 Date from
4. 4 Date To record
垂垂
52
45 Date year
4.6 Date Month
垂垂
4.7Date.Day……
4. 8 Date. AddDays
53
4.9 Date. AddWeeks
.54
4.10 Date. AddMonths
54
4.1 Date. AddQuarters
垂
55
4.2 Date. AddYears
4.3 Date. IsIn Previous Day
56
4. 4 Date. IsIn Current Day
56
4.5Date. IsIn NextDay…
57
4.6 Date. IsIn PreviousWeek
57
4.7 Date. IsIn CurrentWeek
4.8 Date IsIn NextWeek
.58
4.9 Date. IsIn Previous Month
58
4.10 Date IsIn Current Month
59
4.11 Date sIn nextmonth
59
4.12 Date. Isln PreviousQuarter.......
59
4.13 Date. Isln CurrentQuarter
4.14 Date. IsIn NextQuarte
60
4.15 Date sIn Previos
6
4.16 Date.IsIn Current Year
61
4.17 Date IsIn next Year
∴61
4.18 Date sIn year ToDate
4.19 Date. IsLeap Year
62
4.20 Date day ofWeek
62
4.21 Date Day ofYear
4.22 Date. daysIn Month
64
4.23 Date. QuarterofYe
4.24 Date. Weekofmonth
4.25 Date Weekofyear
4.26 Date startofyea
4.27 Date. StartofQu
66
4.28 Date. EndofQuarter
4.29 Date StartofMonth
垂垂
66
4.30 Date startofweek
67
4. 31 Date. StartOfDay
4.32 Date. Endofye
4.33 Date. Endofmonth
4.34 Date. Endofweek
69
4.35 Date. EndofDa
70
4.36 Parameter values
5. Time
5.1 Time from Text
71
5.2 Time. ToText
72
5.3 Time. From
5.4 Time, ToRecord
74
5.5Time. Startofhour.………
74
5.6 Time. Endofhour
74
5.7 Time hour∴
75
5. 8 Time. Minute
翻E翻
75
5.9 Time. Second
176
6. Date Time
76
6.1 Date Time from Text
76
6.2 Date TimeTo Text
6.3 Datetime. from
6.4 Date Time fromfile time
,79
6.5 Date Time To record
∴79
6.6 Datetime.Date∴
6.7 Date Time. Time
80
6. 8 Date Time, AddZone
80
6.9 Date Time locarno
81
6.10 Date Time.fixedlocalnow
.81
6. 11 Date TimeZone. fixedlocaInow
81
6. 12 Date TimeZone. fixed utcnow
81
/. Date timezone
82
7.1 Date TimeZone. from Text
垂垂
82
7.2 Date timezone. to text
7.3 Date TimeZone. from
7. 4 Date TimeZone. from file time
84
75 Date TimeZone torecord
7.6 Date Timezone. Zonehours
86
7.7 Date Timezone. Zone minutes
86
7.8 Date TimeZone. LocaINow……
86
/9 Date Timezone tcoW
87
7.10 Date TimeZone tolocal
87
7.11 Date timezone. Tout
.87
7.12 Date TimeZone SwitchZone
∴88
7.13 Date Timezone. removezone
88
Duration
,90
8.1 Duration from Text
90
8.2 Duration to text
91
8.3 Duration from
翻E翻
91
8. 4 Duration to record
92
8.5 Duration.Days.……
92
8.6 Duration hours
.92
8.7 Duration minutes
93
8.8 Duration seconds
93
8.9 Duration TotalDays
8. 10 Duration Totalhours
94
8. 11 Duration Totalminutes
94
8. 12 Duration Totalseconds
94
9. Record
96
9.1 Information
96
9.2 Transformations
9. 3 Selection
100
9.4 Serialization
9.5 Parameter values
104
10. List
105
10.1 Information
105
10.2 Selection
106
10.3 Transformation functions
垂垂
115
10.4 Membership functions
122
10.5 Set operations………
126
10.6 Ordering...……
28
10.7 Averages
131
10.8 Addition.……
133
10.9 Numerics∴
34
10.10 Generators
垂
135
10.11 Parameter values
38
11. Table
139
11.1 Table construction
139
11.2 Conversions
42
11.3 Information
144
11. 4 Row operations
146
11.5 Column operations
159
11.6 Transformation
…169
11.7 Members
翻E翻
189
11.8 Ordering
195
11.9ther...…
198
11.10 Parameter values
12. cub
201
12.1 Cube Dimensie
201
12.2 Cube, Measures
201
12. 3 Cube AddAnd Expand Dimension column
翻着E垂E
201
12.4 Cube. CollapseAndRemove Columns
203
12.5Cube. Transform……
203
12.6 Cube Display Folders
204
12.7 Cube Attribute Memberld
204
13. Values
205
13.1 Value Equals
205
13.2 Value Nullable equals..................
205
13.3 Value. Compare…
206
13.4 Arithmetic operations
垂垂
206
13.5 Value.as
207
13. 6 Value Is
208
13.7 Value. Replace Type
208
13. 8 Value Type
208
14. Metadata
209
14.1∨aue. Metadata
209
14.2 Value. Remove Metadata
…209
14.3 Value. Replace metadata
15. Accessing data
211
15.1 Return values
211
15.2 Access Database
211
15.3 Active Directory. Domains
211
15.4 Csv, Document∴
212
15.5 Marketplace. Subscriptions
212
15.6 Excel Workbook…
212
15.7 Excel. Current Workbook
,213
15.8 Exchange. Contents
213
159 Facebook Graph…
….213
15.10 File Contents…
213
15.11 Folder Contents
213
15.12 Folder. files
.214
15.13 Hdfs Contents
214
15.14HdfS. Files∴
214
15.15son, document
214
15.16 OData, Fee
215
15.17 Soda. Feed
216
15.18 Sql Databases…
217
15.19 Sql Database
217
15.20 Oracle, Database
218
15.21 DB2 Database
218
15.22 MySQL Database
.219
15.23 Sybase Database
220
6
15.24 Share Point. Contents
220
15.25 Share Point. files
220
15.26 Share Point, Tables
垂垂
221
15.27 Teradata. database
221
15.28 PostgreSQL Database
.221
15.29 Web Contents
222
15.30 Web Page
223
15.31 XmL Document
223
15.32 Xml Tables
224
15.33 HdInsight. Containers....
225
15.34 HdInsight Contents
225
1535 Hdlnsight.「iles.
226
15.36 Azure Storage blobs
226
15.37 Azure Storage. Tables
226
15.38 Sap businessobjects. Universes
227
15.39 Salesforce, Data
227
15.40 Salesforce. Reports
228
15.1 Analysis Services. Databases
228
15.2oDBC. Query,.…,…
.229
16. Uri
231
16.1 Uri. Combine
231
16.2 Uri. Parts
231
16.3 Uri. BuildQueryString
232
16.4 Uri. EscapeDataString
.232
17. Binary Formats
232
17. 1 Example.
233
172 Reading numbers…
233
17. 3 Controlling byte order
237
17. 4 Reading binary data
237
17.5 Reading text
238
17.6 Reading lists
238
17.7 Reading reco
239
17.8 Limiting input
240
17.9 Controlling what comes next
241
17.10 Reading a group of ite
243
17.11 Transforming what was read
245
18. Bin
246
18. 1 Binary From..
246
18.2 Binary To Text
246
18.3 Binary,From…...........,…,,…,…,…
.247
184 Binary: Com bine……
247
18.5 Binary Length
垂
248
18.6 Binary ToList
248
18.7 Binary FromList…
248
18.8 Binary Buffer....
248
19. Lines
249
19.1 Lines. fromText
249
19.2 Lines. From Binary
249
193 Lines. ToBinary.……
250
19. 4 Lines, To Text
251
20. Expression.……
翻E翻
∴252
20.1 Expression Evaluate
252
20.2 Expression. Constant
253
20.3 Expression. ldentifier
253
21 functi
254
21.1 Function
254
21.2 Function Invoke
254
21.3 Function, nvo ke After
翻着E垂E
255
22. Error
255
22 1 Error Record
255
23. Comparer
2
231 Comparer. FromCulture……
256
23.2 Comparer. Equals
256
23.3 Comparer Ordinal
257
23.4 Culture Current
257
24 Splitter
258
24.1 Parameter values
258
8
24.2 Splitter. Split By Delimiter
258
24.3 Splitter. Split TextBy Each Delimiter
258
244 Splitter. SplitTextBy Delimiter.……
垂垂
259
24.5 Splitter SplitText By Whitespace
.259
24.6 Splitter SplitText By Ranges
.260
24.7 Splitter SplitText By Positions
.260
24.8 Splitter. SplitTextByLengths
261
25 Combiner
261
25.1.1 Combiner. Combine Text By Delimiter
261
25. 1.2 Combiner Combine TextBy Each Delimiter.......
262
25.1.3 Combiner. Combine Text By Ranges
263
25. 1.4 Combiner Combine Text By Positions
263
25.1.5 Combiner Combine Text ByLengths
264
26. Replac
265
26.1 Replacer. ReplaceText
26.2 Replacer. Replacevalue
265
27. Type
265
27.1 Type Closed Record
266
27.2Type. Forfunction……,……
.266
27.3 Type ForDist
266
27.4 Type. ForNullable..........
266
27.5 Type. ForRecord
267
27.6 Type ForTable
∴267
27.7 Type Function Parameters
268
27.8Type. Function return…………,
268
27. 9 Type. FunctionRequiredParameters
翻着E垂E
268
27.10 Type IsNullable
268
27.11 Type IsOpen Record
269
27.12 Type ListItem
269
27.13 Type Non Nullable
269
27.14 Type Open Record
269
27.15 Type Record Fields
270
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台,提供交流渠道,下载内容来自于网络,除下载问题外,其它问题请自行百度。
- 本站已设置防盗链,请勿用迅雷、QQ旋风等多线程下载软件下载资源,下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载,请稍后再次尝试;或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎,请到消费记录里找到下载记录反馈给我们,经确认后退回积分.
- 如下载前有疑问,可以通过点击"提供者"的名字,查看对方的联系方式,联系对方咨询.