Forum Discussion

javieezy's avatar
javieezy
Helper I
3 years ago
Solved

Help - 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...
  • javieezy's avatar
    3 years ago

    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.