Forum Discussion
javieezy
Helper I
Helper IHelp - date range lookup between queries
Dear all, I have 2 tables in 2 queries: -1: Period table: -2: Data table: What I need is: -Depends on the Columna "SimpleDateLogOff" in Table 2, Add a column in Table 2...
Found a way:
Add a custom column in Period Table using “List.Dates" function, to have all the dates between a period.
Then just merge 2 tables.
v-yalanwu-msft
Community Support
Community SupportHi, javieezy ;
Or you could in power query. first list.dates the merge it.
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.