let
//Country Source - Change type - add custom column with 1 for all rows for many to many join
tCountry = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCvVWitUBUsFKsbEA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Country = _t]),
CountryType = Table.TransformColumnTypes(tCountry,{{"Country", type text}}),
CountryCustom = Table.AddColumn(CountryType, "Custom", each 1),
//Month Source - Change type - add custom column with 1 for all rows for many to many join
tMonth = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSBEyagkkzMGkOJi3ApCWYNDSAUBDdhkDtsQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Month = _t]),
MonthType = Table.TransformColumnTypes(tMonth,{{"Month", Int64.Type}}),
MonthCustom = Table.AddColumn(MonthType, "Custom", each 1),
//Name Source - Change type - add custom column with 1 for all rows for many to many join
tName = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WcspPUorViVZySSxLBTOCE/NSihKVYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t]),
NameType = Table.TransformColumnTypes(tName,{{"Name", type text}}),
NameCustom = Table.AddColumn(NameType, "Custom", each 1),
MergeCountryMonth = Table.NestedJoin(CountryCustom,{"Custom"},MonthCustom,{"Custom"},"NewColumn",JoinKind.LeftOuter),
ShowMonth = Table.ExpandTableColumn(MergeCountryMonth, "NewColumn", {"Month"}, {"NewColumn.Month"}),
MergeWithName = Table.NestedJoin(ShowMonth,{"Custom"},Name,{"Custom"},"NewColumn",JoinKind.LeftOuter),
ShowName = Table.ExpandTableColumn(MergeWithName, "NewColumn", {"Name"}, {"NewColumn.Name"}),
#"Removed Columns" = Table.RemoveColumns(ShowName,{"Custom"}),
#"Inserted Merged Column" = Table.AddColumn(#"Removed Columns", "Merged", each Text.Combine({Text.From([Country], "en-GB"), Text.From([NewColumn.Month], "en-GB"), Text.From([NewColumn.Name], "en-GB")}, ""), type text),
#"Removed Other Columns" = Table.SelectColumns(#"Inserted Merged Column",{"Merged"})
in
#"Removed Other Columns"