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

[daircom]

Hi all,

I have the dataset below, which has an as_of_date (this is a snapshot date). So if 04/09/2024 is selected all data for this day shows up. I want to create a slicer which can filter the data in a way that I can select a single As_of_date, and that it selects all As_of_date up to and including the selected date. So if I select the As_of_date 05/09/2024 from the slicer, it should also show all the data from 05/09/2024, but also 04/09/2024 and 03/09/2024 etc.

In short: I want to select a single date in the slicer and it should filter all data up to and including that date.

[DataInsights · Accepted solution]

@daircom,

Try a date slicer with Style "Before":

[Anonymous · Accepted solution]

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.

[DataInsights · Accepted solution]

@daircom,

Try a date slicer with Style "Before":