Forum Discussion
Date Betwen
Hello guys,
Im trying to solve a problem i found while building my data model.
I got 2 differents tables :
- One with the account balance by month for each tenant.
| Tenant Account | Month | Account balance |
| 481 | 06-2022 | 125 € |
| 481 | 07-2022 | 422 € |
| 481 | 08-2022 | 23 € |
- One with the litigation phase of the tenant, with the start date & the end date of the phase.
| Tenant Account | Litigation phase | Start Date | End Date |
| 481 | Phase 1 | 13/05/2021 | 23/08/2021 |
| 481 | Phase 2 | 03/01/2022 | 24/07/2022 |
| 481 | Phase 1 | 06/08/2022 | 23/08/2022 |
I have to associate the correct phase to each line in the first table. Any idea ?
Thanks for reading 😄
Hugo_RGS , Create a new column in table 1, convert account month into date or create a date from it
maxx(filter(Table2, Table2[tenant Account] = table1[tenant Account] && table1[Account Date]>= Table2[Start Date] && Table1[Account Date] <= Table2[End date]) , Table2[Litigation phase])
1 Reply
- amitchandak
Super User
Hugo_RGS , Create a new column in table 1, convert account month into date or create a date from it
maxx(filter(Table2, Table2[tenant Account] = table1[tenant Account] && table1[Account Date]>= Table2[Start Date] && Table1[Account Date] <= Table2[End date]) , Table2[Litigation phase])