Create a Merged Deadline and Service History Table

Here's your deadline explosion for the assets table.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dZI9CsMwDEbv4jkl+rWkuXspdAwZeo2evk5TIscQD+ZD5vFky8tSXvfn48bQFpapILXt/TEDZmPxrTTjTECYsZZ16kFKEMWQdC/VBP9RBpATrOak7tBpKKMNoHStqpIrcU1NJx9b1e1o5yCqhTmnha+vWFPo5C5afz3UBC+E1oHSlnNAaiRjDKAfnTIDIraR9A95xJGLFAoBU3BYWjSjn0GEBImifQDibnR6Mq5f", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Frequency = _t, #"Installed Product ID" = _t, #"Start Date" = _t, #"End Date" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Start Date", type date}, {"End Date", type date}, {"Frequency", Int64.Type}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Deadline", (k)=> List.Generate(()=>Date.AddMonths(k[Start Date],k[Frequency]),each _ <= k[End Date], each Date.AddMonths(_,k[Frequency]))),
    #"Expanded Deadline" = Table.ExpandListColumn(#"Added Custom", "Deadline"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Expanded Deadline",{{"Deadline", type date}})
in
    #"Changed Type1"

 

You can now compare that against the service dates.  Not sure what your expected outcome is for the sample data you provided.

 

Hi quincy_p 

Please see the attached pbix. If  this isnt what you're looking for, please a provide a sample result  using the same sample data.

 

Note: Joins/merges can be a very expensive process in Power Query.

Hi,

Based on the 2 tables which you have shared, show the expected result very clearly.