blocks|key|480265|text|2以下代码中的解决方案。请注意，每种方法都使用"PreviousStep“作为基础，因此它们是单独的解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|480266|let
++++Source+=+Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
++++PreviousStep+=+Table.TransformColumnTypes(Source,{{"Date",+type+date},+{"Letter",+type+text}}),

++++//+1.+Add+a+column+to+the+original+table+with+the+MaxDate+for+each+letter
++++//++++"earlier"++is+just+the+name+of+a+function+parameter;+it+could+as+well+have+been+"x"+or+"MarcelBeug"
++++AddedMaxDate+=+Table.AddColumn(PreviousStep,+"MaxDate",+(earlier)+=>+List.Max(Table.SelectRows(PreviousStep,+each+[Letter]+=+earlier[Letter])[Date])),

++++//+2.+Group+by+letter+and+get+the+MaxDate+for+each+letter
++++GroupedOnLetter+=+Table.Group(PreviousStep,+{"Letter"},+{{"MaxDate",+each+List.Max([Date]),+type+date}})
in
++++GroupedOnLetter|code-block|syntax|javascript|480267|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

2 Solutions in the code below. Notice that each uses "PreviousStep" as basis, so these are separate solutions.

<pre><code>let
 Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
 PreviousStep = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Letter", type text}}),

 // 1. Add a column to the original table with the MaxDate for each letter
 // "earlier" is just the name of a function parameter; it could as well have been "x" or "MarcelBeug"
 AddedMaxDate = Table.AddColumn(PreviousStep, "MaxDate", (earlier) =&gt; List.Max(Table.SelectRows(PreviousStep, each [Letter] = earlier[Letter])[Date])),

 // 2. Group by letter and get the MaxDate for each letter
 GroupedOnLetter = Table.Group(PreviousStep, {"Letter"}, {{"MaxDate", each List.Max([Date]), type date}})
in
 GroupedOnLetter
</code></pre>

blocks|key|960876|text|简而言之，这个函数没有精确的匹配。尽管如此，您可以使用其他方法来产生相同的结果。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|960877|为了重现Microsoft+in+help+for+EARLIER+function提供的示例，您可以使用以下代码(排名前示例中给出的table1等于表)：|offset|length|style|CODE|960878|let
++++Source+=+Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TVNNaxtBDP0rxuSoivn%2BuMYlLSUFE4f2YHIYd4d48Xq3rO1C/n01o1mc4%2Bi9kZ6epP1%2BLcMa1o/94cvuOM3XCz0epHUgnccQ1m%2BwXytXGae8ekl/TpWhlACvBHrBDL8wdtc0dpWiLTgV0EVm1CrT9Trky4ooq016z5VnI2ij0OjKs402nVePM1XLrMgEcEaj8ZVU9czpxAmcAik1SlcxGSm2SX/5m4eoDVpToSJyc0z9WLEAwXgUrcX6a8hpzDNb4CAEhU5VuIjfzGk8XZoeGSVYpVBwd%2BX31zynfhjyjRM4A9FZ1NyWFhR7ymPX0hsJ0RuUbJ%2Bs6DSzt96QtR4d96MK9m2Y/uVmfABtNVrWbSj2newc8iEtwjUoS401O2Rh5NQtyq0HZyNGFq4ZHs6Lz1aCjAopXmFV4I9uTtd%2BGlfbZfyR3IkafTOvJPlBneUPbj1GMCouMFkA6%2Bf%2B/VhLcKjofp5aNmlBkKQ23JLs53QbrzSoVdkp3iYDWlgIzqBi6VJ9Jj7N6cxMA1ZSE16ga/XLTm3TOPZsPv8uora5SwNLMIIkK1Q8EF02bHs78xZJBS5alK1bCr1Mqbtro7%2BWfHPRoeZNk2Yh3XVpcNqBjgE9myuLrl3qaHg8GUUr5RYbVKlzP0kdLHhBJ9kOrsjfLQaWndCEWcZK8dfF7wcZIrkRUXNe7Ss6tzN8vR2WxTIQtMLQJl9Y023ux/d7o1JTHVOH0MyQ7hPv3isdh7F01gYFH5Aqvf7KF5akyLEYBYrmVpH0%2B5jz0C4nADEq%2BvYf",+BinaryEncoding.Base64),+Compression.Deflate)),+let+_t+=+((type+text)+meta+[Serialized.Text+=+true])+in+type+table+[ProductSubcategoryKey+=+_t,+EnglishProductSubcategoryName+=+_t,+TotalSubcategorySales+=+_t]),
++++table1+=+Table.TransformColumnTypes(Source,{{"ProductSubcategoryKey",+Int64.Type},+{"EnglishProductSubcategoryName",+type+text},+{"TotalSubcategorySales",+Currency.Type}},+"en-US"),
++++AddCount+=+Table.AddColumn(
++++++++++++++table1,+
++++++++++++++"SubcategoryRanking",+//(a)+is+a+parameter+for+function,+which+equals+current+record,+and+function+should+return+value+for+new+cell+of+"SubcategoryRanking"
++++++++++++++(a)=>+Table.RowCount(+
++++++++++++++++++++++++Table.SelectRows(+
++++++++++++++++++++++++table1,+//(b)+equals+whole+table1.+This+function+returns+table+filtered+by+given+criteria
++++++++++++++++++++++++(b)+=>++b[TotalSubcategorySales]+<+a[TotalSubcategorySales])+
++++++++++++++++++++)+%2B+1,
++++++++++++++Int64.Type)
in
++++AddCount|code-block|syntax|javascript|960879|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ee634551.aspx^0|0|Q|7|4|12|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@$D|W|E|X|F|G]]|9|@$D|Y|E|Z|1|10]]|A|$]]|$1|H|3|I|5|J|7|11|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

In short, there is no exact match for this function. Still, you can use other ways that can produce same results.

To reproduce example offered by <a href="https://msdn.microsoft.com/en-us/library/ee634551.aspx" rel="nofollow noreferrer">Microsoft in help for <code>EARLIER</code> function</a>, you can use following code (table1 equals table given in the example before ranking):

<pre><code>let
 Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TVNNaxtBDP0rxuSoivn+uMYlLSUFE4f2YHIYd4d48Xq3rO1C/n01o1mc4+i9kZ6epP1+LcMa1o/94cvuOM3XCz0epHUgnccQ1m+wXytXGae8ekl/TpWhlACvBHrBDL8wdtc0dpWiLTgV0EVm1CrT9Trky4ooq016z5VnI2ij0OjKs402nVePM1XLrMgEcEaj8ZVU9czpxAmcAik1SlcxGSm2SX/5m4eoDVpToSJyc0z9WLEAwXgUrcX6a8hpzDNb4CAEhU5VuIjfzGk8XZoeGSVYpVBwd+X31zynfhjyjRM4A9FZ1NyWFhR7ymPX0hsJ0RuUbJ+s6DSzt96QtR4d96MK9m2Y/uVmfABtNVrWbSj2newc8iEtwjUoS401O2Rh5NQtyq0HZyNGFq4ZHs6Lz1aCjAopXmFV4I9uTtd+GlfbZfyR3IkafTOvJPlBneUPbj1GMCouMFkA6+f+/VhLcKjofp5aNmlBkKQ23JLs53QbrzSoVdkp3iYDWlgIzqBi6VJ9Jj7N6cxMA1ZSE16ga/XLTm3TOPZsPv8uora5SwNLMIIkK1Q8EF02bHs78xZJBS5alK1bCr1Mqbtro7+WfHPRoeZNk2Yh3XVpcNqBjgE9myuLrl3qaHg8GUUr5RYbVKlzP0kdLHhBJ9kOrsjfLQaWndCEWcZK8dfF7wcZIrkRUXNe7Ss6tzN8vR2WxTIQtMLQJl9Y023ux/d7o1JTHVOH0MyQ7hPv3isdh7F01gYFH5Aqvf7KF5akyLEYBYrmVpH0+5jz0C4nADEq+vYf", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [ProductSubcategoryKey = _t, EnglishProductSubcategoryName = _t, TotalSubcategorySales = _t]),
 table1 = Table.TransformColumnTypes(Source,{{"ProductSubcategoryKey", Int64.Type}, {"EnglishProductSubcategoryName", type text}, {"TotalSubcategorySales", Currency.Type}}, "en-US"),
 AddCount = Table.AddColumn(
 table1, 
 "SubcategoryRanking", //(a) is a parameter for function, which equals current record, and function should return value for new cell of "SubcategoryRanking"
 (a)=&gt; Table.RowCount( 
 Table.SelectRows( 
 table1, //(b) equals whole table1. This function returns table filtered by given criteria
 (b) =&gt; b[TotalSubcategorySales] &lt; a[TotalSubcategorySales]) 
 ) + 1,
 Int64.Type)
in
 AddCount
</code></pre>

blocks|key|967756|text|我认为您可以使用GroupBy函数按字母对数据进行分组，并找到date列的最大值。所以你的代码应该是这样的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|967757|=+Table.Group(#"Previous+step",+{"Letter"},+{{"Max+Date",+each+List.Max([Date]),+type+date}})|code-block|syntax|javascript|967758|entityMap^0|I|2|V|4|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

I think you can use the GroupBy function to group the data by Letter and find the Max of the date column. So your code should look like.

<pre><code>= Table.Group(#"Previous step", {"Letter"}, {{"Max Date", each List.Max([Date]), type date}})
</code></pre>

Is there an an equivalent to EARLIER in M/Power Query?

Say, I have a table with lots of different dates in column DATE and a smaller number of letters in column LETTER. I now want the maximum date for each letter.

In DAX, I would use something like CALCULATE(MAX([Date]),FILTER(ALL(Table),[Letter]=EARLIER([Letter])).

How would I achieve the same in M?

Thanks

DAX EARLIER() function in Power Query

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

在M/Power Query中有没有与前面的等价物？比方说，我有一个表，在DATE列中有很多不同的日期，在LETTER列中有较少的字母。我现在想要每封信的最大日期。在DAX中，我会使用像CALCULATE(MAX(日期)，FILTER(ALL(表)，Letter=EARLIER(字母))这样的东西。我如何在M中实现同样...

问Power Query中的DAX EARLIER()函数
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Power Query中的DAX EARLIER()函数EN