Date Betwen

[Hugo_RGS]

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 😄

[amitchandak · Accepted solution]

@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])