Missing Dates

Hi BennyA ,

Consider using Fill up if the last record of each group [DetachDate] is not the null. 

In other cases, consider grouping [report date] first and then using conditional judgment to replace null.

= Table.Group(YourPreviousStepName, {"Report Date"}, {{"DetachDate", each List.Transform([DetachDate],(x) => if x = null then List.Max([DetachDate]) else x )}})

All codes in Adavance Editor.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtc3AiIDQ1MlHaW80pwcpVidQS9oqm9kCGQbGdDEDBJNJ8cgVBkTfTOQhAWyDSNEzETfCBQOhrjFYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Report Date" = _t, DetachDate = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Report Date", type date}, {"DetachDate", type date}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Report Date"}, {{"DetachDate", each List.Transform([DetachDate],(x) => if x = null then List.Max([DetachDate]) else x )}}),
    #"Expanded DetachDate" = Table.ExpandListColumn(#"Grouped Rows", "DetachDate")
in
    #"Expanded DetachDate"

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum