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...
Need Help
  • javieezy's avatar
    javieezy
    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. 

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, javieezy ;

You could create a measure or column by dax.

Measure.

Measure = CALCULATE(MAX('Period'[Periodo]),FILTER('Period',MAX('Data'[SimpleDateLogoff]) in CALENDAR([Start],[Finish])))

Column.

Column = CALCULATE(MAX('Period'[Periodo]),FILTER('Period','Data'[SimpleDateLogoff] in CALENDAR([Start],[Finish])))

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.