Transformar tempo entre datas em linhas

Boa tarde marcelocostafil ,

Deves adicionar uma nova coluna calculada com o seguinte código:

try { Number.From (Date.From ([Data])) ..
 Number.From(Date.From ([DataSaid]))}

 otherwise

 { Number.From (Date.From ([Data])) ..
 Number.From(Date.From (DateTime.LocalNow()))}

Depois expandes a coluna e formatas com data:

Atenção que no caso de a coluna Data ser maior que o dia de hoje o código dá nulo:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjTTNzDUNzIwMlYwNLQyMrQyNFPSUXJ29PMEUYl5mYeXJ+YAma4hrkDSycWnOCUxLa04JS0FyDUEYQuEASZWJhZWpuYgUUuEqKmVibmViYFSrE60ElDQwBwkbkKMdWkpxRC7ivFaBjHZjCYmxwIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Data = _t, CodPorto = _t, CodPortoDesc = _t, Carregador = _t, Referencia = _t, Confirmado = _t, #"Data confi" = _t, DataSaid = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Data", type datetime}, {"CodPorto", type text}, {"CodPortoDesc", type text}, {"Carregador", type text}, {"Referencia", type text}, {"Confirmado", Int64.Type}, {"Data confi", type datetime}, {"DataSaid", type datetime}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each try { Number.From (Date.From ([Data])) ..
 Number.From(Date.From ([DataSaid]))}

 otherwise

 { Number.From (Date.From ([Data])) ..
 Number.From(Date.From (DateTime.LocalNow()))}),
    #"Expanded Custom" = Table.ExpandListColumn(#"Added Custom", "Custom"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Custom",{{"Custom", type date}})
in
    #"Changed Type1"