MinX Power M Query Equivalent

[kjm5200]

Hey All,

I am trying to figure out how to use the equivalent of the dax MinX formula using power m query.  I am aware how to accomplish this through Dax but its important that this is accomplished through power query. 

Below is a set of same data

Symbol	Date
AA	1-Jan
AA	2-Jan
BB	3-Jan
BB	4-Jan
CC	4-Jan
DD	5-Jan

What I would like to see if 3 columns.  Column A is symbol, Column B is Date and Column 3 is the min date by symbol ignoring other columns.  The desired result is below.

Symbol	Date	Min Date
AA	1-Jan	1-Jan
AA	2-Jan	1-Jan
BB	3-Jan	3-Jan
BB	4-Jan	3-Jan
CC	4-Jan	4-Jan
DD	5-Jan	5-Jan

Can anyone help?  Thank you in advance!

Kevin

[Anonymous · Accepted solution]

The key here to is perform a GroupBy with a Minimum aggregate on the data, and then merge the result back to the table before you grouped it.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcnRU0lEy1DXUNTIwtFCK1YGLGCFEnJzAIsYYIiYIEWdndBEXF7CIKVQkFgA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Group = _t, Date = _t]),
    TypeChange = Table.TransformColumnTypes(Source,{{"Date", type date}}),
    Group = Table.Group(TypeChange, {"Group"}, {{"MinDate", each List.Min([Date]), type date}}),
    Merge = Table.NestedJoin(TypeChange,{"Group"},Group,{"Group"},"TypeChange",JoinKind.LeftOuter),
    Expand = Table.ExpandTableColumn(Merge, "TypeChange", {"MinDate"}, {"MinDate"})
in
    Expand