Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
3 years ago

Display values based on filter from different table

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?

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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?