Sum and Filter from two tables with multiple criteria and date

[Anonymous]

@Sahir_Maharaj  was a champ helping me with a smiliar problem (Solved: Lookupvalue two tables with multiple criteria - Microsoft Fabric Community). In this example I would want to add a date as well.

This is the two tables I have but I am struggling to add the date columns to the formula.

Tabel1:

Cost Group	Date	Column to Calculate
ID 1	2023-01	CALCULATE(SUM('Tabel2'[Costs]),FILTER('Tabel2','Tabel2'[Cost Group] = 'Tabel1'[Cost Group] && ('Tabel2'[Account] = "ABC1 || 'Tabel2'[Account] = "ABC2"))) = 8000

Tabel2:

Cost Group	Account	Date	Costs
ID 1	ABC1	2023-01	1000
ID 1	ABC1	2023-01	2000
ID 1	ABC2	2023-01	5000
ID 1	ABC1	2023-02	500

[ryan_mayu]

@Anonymous 

is this what you want?

CALCULATE(SUM('Tabel2'[Costs]),FILTER('Tabel2','Tabel2'[Cost Group] = 'Tabel1'[Cost Group]&&'Tabel2'[Date] = 'Tabel1'[Date] && ('Tabel2'[Account] = "ABC1 || 'Tabel2'[Account] = "ABC2"))) = 8000