Forum Discussion
DuncanYeah
Helper III
Helper IIIDate Pairing
Dear All, I have two date columns from two different table. Table 1 A 1 Mar 2 Mar 3 Mar 4 Mar 5 Mar 6 Mar 7 Mar 8 Mar Table B 1 Mar 4 Mar 7 M...
Hi DuncanYeah , another solution you can look at. I'll leave the image of output and M code used. Thanks!
let
Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
MainTable = Table.TransformColumnTypes(Source,{{"Table A", type datetime}}),
Dates = Excel.CurrentWorkbook(){[Name = "Table6"]}[Content][#"Table B "],
Match = Table.AddColumn(MainTable,"Date", each try Dates{List.PositionOf(Dates,Record.ToList(_){0})} otherwise null),
Table = Table.FillDown(Match,{"Date"})inTable
v-karpurapud
Community Support
Community SupportHi DuncanYeah
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.