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.
- One with the litigation phase of the tenant, with the start date & the end date of the phase.
I have to associate the correct phase to each line in the first table. Any idea ? Thanks for reading 😄
Go to 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])
View solution in original post
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.