How to write dax to filter up to and including a date

daircom,

Try a date slicer with Style "Before":

Hi, daircom 

Based on your information, I create a sample table:

Create another table:

Then create a new measure and try the following DAX expression:

FilteredDates = 
VAR _Slicer = MAX('Table 2'[As_of_date])
RETURN 
IF(MAX('Table'[As_of_date])>_Slicer,BLANK(),SUM('Table'[Volume of goods]))

Put this measure in table view, and put Table 2[As_of_data] in slicer.

Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.