Display values based on filter from different table

[joshua1990]

Hi all!

I have a transactional table that is linked to our calendar table via Date column.

This values I have displayed in a simple matrix:

	2023-Jan	2023-Feb	2023-Mar	2023-Apr
	500	600	750	656

Then I have a second table that is not linked to the calendar table an has this structure:

Group	Date
A	07.01.2023
B	15.02.2023

This table I would like to use as a filter in the dax measure. Here I would like to sum up the values again but just until the Date that is displayed in the calumn [Date].

Something like:

CALCULATE(SUM(Sales[Value]), FILTER(Calendar, Calendar[Date] <= Table2[Date]).

How would you achieve that with DAX?

[lbendlin]

please provide more details on the transaction table. Does it have an actual transaction date (not only a month), does it contain the Group column?