Power+Query+函数库+(February+2015+含标签).pdf包含部分自学时的笔记；

文件名称: Power+Query+函数库+(February+2015+含标签).pdf

所属分类: 其它

开发工具:

文件大小: 3mb

下载次数: 0

上传时间: 2019-07-07

提供者: weixin_********

下载 (3mb)

不能下载？报告错误

详细说明：包含部分自学时的笔记；适合初学者参考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

(系统自动生成,下载前可以参看下载内容)