当前位置：首页 > news >正文

网站蜘蛛来访纪录/seo培训赚钱

news 2025/7/9 16:49:32

网站蜘蛛来访纪录,seo培训赚钱,广州推动优化防控措施落地,人民日报客户端下载量分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！Power Query的本质——M语言。Power Query 在…

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

Power Query的本质——M语言。

Power Query 在Excel2010和2013中是以插件形式存在的，Excel2016中已经内置这一功能了，其可见微软对其的重视。
值得欣慰的是，PQ不仅为我们快速导入不同数据源数据提供便利，也为我们提供了一系列新的函数，PQ中的公式简称为M公式，与PowerPivot中的DAX表达式是两兄弟。

什么是M语言：用一种既定的函数公式来记录在power query中的操作。这些函数公式的集合，统称为M语言。

怎样学M语言的公式？

（https://msdn.microsoft.com/library/Mt253322?ui=en-US&rs=en-US&ad=US）

使用M语言的注意事项：

函数区分大小写

数据类型很严格

没有单元格引用的概念

必选与可选参数的区分

下面则是具体的公式：

Power Query (informally known as "M") formula categories

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

About

The following tables describe the Power Query formula categories that can be used to manually create or modify queries. These formula functions can also be used in the Power BI Designer, in the Query view.

Number

Constants

Function	Description
Number.NaN	Represents 0/0.
Number.NegativeInfinity	Represents -1/0.
Number.PositiveInfinity	Represents 1/0.
Number.Epsilon	Returns the smallest possible number.
Number.E	Returns 2.7182818284590451, the value of e up to 16 decimal digits.
Number.PI	Returns 3.1415926535897931, the value for Pi up to 16 decimal digits.

Information

Function	Description
Number.IsNaN	Returns true if a value is Number.NaN.
Number.IsEven	Returns true if a value is an even number.
Number.IsOdd	Returns true if a value is an odd number.

Conversion and formatting

Function	Description
Number.FromText	Returns a number value from a text value.
Number.ToText	Returns a text value from a number value.
Number.From	Returns a number value from a value.
Byte.From	Returns a 8-bit integer number value from the given value.
Int8.From	Returns a signed 8-bit integer number value from the given value.
Int16.From	Returns a 16-bit integer number value from the given value.
Int32.From	Returns a 32-bit integer number value from the given value.
Int64.From	Returns a 64-bit integer number value from the given value.
Single.From	Returns a Single number value from the given value.
Double.From	Returns a Double number value from the given value.
Decimal.From	Returns a decimal number value from the given value.
Currency.From	Returns a currency value from the given value.
Percentage.From	Returns a percentage value from the given value.

Rounding

Function	Description
Number.RoundDown	Returns the largest integer less than or equal to a number value.
Number.RoundUp	Returns the larger integer greater than or equal to a number value.
Number.RoundTowardZero	Returns Number.RoundDown(x) when x >= 0 and Number.RoundUp(x) when x < 0.
Number.RoundAwayFromZero	Returns Number.RoundUp(value) when value >= 0 and Number.RoundDown(value) when value < 0.
Number.Round	Returns a nullable number (n) if value is an integer.

Operations

Function	Description
Number.Abs	Returns the absolute value of a number.
Number.Sign	Returns 1 for positive numbers, -1 for negative numbers or 0 for zero.
Number.IntegerDivide	Divides two numbers and returns the whole part of the resulting number.
Number.Mod	Divides two numbers and returns the remainder of the resulting number.
Number.Power	Returns a number raised by a power.
Number.Sqrt	Returns the square root of a number.
Number.Exp	Returns a number representing e raised to a power.
Number.Ln	Returns the natural logarithm of a number.
Number.Log	Returns the logarithm of a number to the base.
Number.Log10	Returns the base-10 logarithm of a number.
Number.Factorial	Returns the factorial of a number.
Number.Combinations	Returns the number of combinations of a given number of items for the optional combination size.
Number.Permutations	Returns the number of total permutatons of a given number of items for the optional permutation size.

Random

Function	Description
Number.Random	Returns a random fractional number between 0 and 1.
Number.RandomBetween	Returns a random number between the two given number values.

Trigonometry

Function	Description
Number.Acos	Returns the arccosine of a number.
Number.Asin	Returns the arcsine of a number.
Number.Atan	Returns the arctangent of a number.
Number.Atan2	Returns the arctangent of the division of two numbers.
Number.Cos	Returns the cosine of a number.
Number.Cosh	Returns the hyperbolic cosine of a number.
Number.Sin	Returns the sine of a number.
Number.Sinh	Returns the hyperbolic sine of a number.
Number.Tan	Returns the tangent of a number.
Number.Tanh	Returns the hyperbolic tangent of a number.

Bytes

Function	Description
Number.BitwiseAnd	Returns the result of a bitwise AND operation on the provided operands.
Number.BitwiseNot	Returns the result of a bitwise NOT operation on the provided operands.
Number.BitwiseOr	Returns the result of a bitwise OR operation on the provided operands.
Number.BitwiseShiftLeft	Returns the result of a bitwise shift left operation on the operands.
Number.BitwiseShiftRight	Returns the result of a bitwise shift right operation on the operands.
Number.BitwiseXor	Returns the result of a bitwise XOR operation on the provided operands.

Text

Information

Function	Description
Text.Length	Returns the number of characters in a text value.

Text Comparisons

Function	Description
Character.FromNumber	Returns a number to its character value.
Character.ToNumber	Returns a character to its number value.
Text.From	Returns the text representation of a number, date, time, datetime, datetimezone, logical, duration or binary value. If a value is null, Text.From returns null. The optional culture parameter is used to format the text value according to the given culture.
Text.FromBinary	Decodes data from a binary value in to a text value using an encoding.
Text.NewGuid	Returns a Guid value as a text value.
Text.ToBinary	Encodes a text value into binary value using an encoding.
Text.ToList	Returns a list of characters from a text value.
Value.FromText	Decodes a value from a textual representation, value, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value, a DateTime value, a Duration value, or a text value. The empty text value is interpreted as a null value.

Extraction

Function	Description
Text.At	Returns a character starting at a zero-based offset.
Text.Range	Returns a number of characters from a text value starting at a zero-based offset and for count number of characters.
Text.Start	Returns the count of characters from the start of a text value.

Function	Description
Text.End	Returns the number of characters from the end of a text value.

Modification

Function	Description
Text.Insert	Returns a text value with newValue inserted into a text value starting at a zero-based offset.
Text.Remove	Removes all occurrences of a character or list of characters from a text value. The removeChars parameter can be a character value or a list of character values.
Text.RemoveRange	Removes count characters at a zero-based offset from a text value.
Text.Replace	Replaces all occurrences of a substring with a new text value.
Text.ReplaceRange	Replaces length characters in a text value starting at a zero-based offset with the new text value.

Membership

Function	Description
Text.Contains	Returns true if a text value substring was found within a text value string; otherwise, false.
Text.EndsWith	Returns a logical value indicating whether a text value substring was found at the end of a string.
Text.PositionOf	Returns the first occurrence of substring in a string and returns its position starting at startOffset.
Text.PositionOfAny	Returns the first occurrence of a text value in list and returns its position starting at startOffset.
Text.StartsWith	Returns a logical value indicating whether a text value substring was found at the beginning of a string.

Transformations

Function	Description
Text.Clean	Returns the original text value with non-printable characters removed.
Text.Combine	Returns a text value that is the result of joining all text values with each value separated by a separator.
Text.Lower	Returns the lowercase of a text value.

查看全文

http://www.jmfq.cn/news/4750723.html