If you have additional transformations to do after this step, you can also do this cross join in the query editor. Please see the M code below that does so with your example data. Just create a blank query, go to Advanced Editor, and replace the code there with this.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ZY5BCsAwCAT/knMMq4navqXk/99oJK1QepKR2WWvq8h5OEapxVTZ1mUQOgkEC2SBbJj1kTX+JrAWMTbCeHVwQurRKQ7o1oWg2d7/uscUV+5Nv4Ur67lszhs=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Id = _t, Amount = _t, DateA = _t, DateB = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Id", Int64.Type}, {"Amount", type number}, {"DateA", type text}, {"DateB", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Date Main", each List.Dates(#date(2020,1,1), 366, #duration(1,0,0,0))),
#"Expanded Date Main" = Table.ExpandListColumn(#"Added Custom", "Date Main"),
#"Changed Type1" = Table.TransformColumnTypes(#"Expanded Date Main",{{"Date Main", type date}})
in
#"Changed Type1"
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Did I answer your question? Mark my post as a solution! Kudos are also appreciated! To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypa HoosierBI on YouTube
