title: Extract min max date of a row with multiple dates
body: <p>How can I split the min and the max date which is located in a row with multiplate dates</p>
  
  <p>This is in Power Query</p>
  
  <pre><code>8/31/2018, 8/29/2018, 4/9/2018, 8/29/2018, 8/29/2018
  </code></pre>
  
  <p>Result in different Columns </p>
  
  <pre><code>min            max
  29/8/2019      4/9/2019
  </code></pre>
  
  <p>Can anybody help me to figure it out?</p>
  
  <p>Code:
  = Table.TransformColumns(#"Added Custom4", {"FechaFinalTarea", each Text.Combine(List.Transform(_, Text.From), ", "), type text})</p>
  
  <p><a href="https://i.stack.imgur.com/stjaB.png" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>Full code:
  let
      Source = Etapa_1_Caricam,
      #"Grouped Rows" = Table.Group(Source, {"Num Form"}, {{"mynewtable", each _, type table [Num Form=text, DupForm=text, Creado En=date, FechaCreac=date, SLA=number, Initiator Name=text, Business Unit=text, BU Description=text, Tipo Form=text, Descripción del proyecto=text, Texto tarea=text, Field12=number, Task Assigned=text, Status=number]}}),
      #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Task_Etapa1", each Table.Column([mynewtable],"Texto tarea")),
      #"Extracted Values" = Table.TransformColumns(#"Added Custom", {"Task_Etapa1", each Text.Combine(List.Transform(<em>, Text.From), ", "), type text}),
      #"Added Custom1" = Table.AddColumn(#"Extracted Values", "Iniciador", each Table.Column([mynewtable],"Initiator Name")),
      #"Extracted Values1" = Table.TransformColumns(#"Added Custom1", {"Iniciador", each Text.Combine(List.Transform(</em>, Text.From), ", "), type text}),
      #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Extracted Values1", {{"Iniciador", each Text.BeforeDelimiter(<em>, ", "), type text}}),
      #"Added Custom2" = Table.AddColumn(#"Extracted Text Before Delimiter", "Custom", each Table.Column([mynewtable],"Descripción del proyecto")),
      #"Extracted Values2" = Table.TransformColumns(#"Added Custom2", {"Custom", each Text.Combine(List.Transform(</em>, Text.From), ", "), type text}),
      #"Inserted Text Before Delimiter" = Table.AddColumn(#"Extracted Values2", "Text Before Delimiter", each Text.BeforeDelimiter([Custom], ","), type text),
      #"Removed Columns" = Table.RemoveColumns(#"Inserted Text Before Delimiter",{"Custom"}),
      #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Text Before Delimiter", "Descripcion del Proyecto"}}),
      #"Added Custom3" = Table.AddColumn(#"Renamed Columns", "FechaInicio", each Table.Column([mynewtable],"Creado En")),
      #"Extracted Values3" = Table.TransformColumns(#"Added Custom3", {"FechaInicio", each Text.Combine(List.Transform(<em>, Text.From), ", "), type text}),
      #"Inserted Text Before Delimiter1" = Table.AddColumn(#"Extracted Values3", "Text Before Delimiter", each Text.BeforeDelimiter([FechaInicio], ", "), type text),
      #"Inserted Text After Delimiter" = Table.AddColumn(#"Inserted Text Before Delimiter1", "Text After Delimiter", each Text.AfterDelimiter([FechaInicio], ", "), type text),
      #"Removed Columns1" = Table.RemoveColumns(#"Inserted Text After Delimiter",{"Text After Delimiter", "Text Before Delimiter"}),
      #"Extracted Text Before Delimiter1" = Table.TransformColumns(#"Removed Columns1", {{"FechaInicio", each Text.BeforeDelimiter(</em>, ", "), type text}}),
      #"Added Custom4" = Table.AddColumn(#"Extracted Text Before Delimiter1", "FechaFinalTarea", each Table.Column([mynewtable],"FechaCreac")),
      #"Extracted Values4" = Table.TransformColumns(#"Added Custom4", {"FechaFinalTarea", each Text.Combine(List.Transform(_, Text.From), ", "), type text})
  in
      #"Extracted Values4"</p>