Single Date Selection filtering data up to the selected date

Hi Anonymous ,

If your table contains the continuous date column, you could try the way below. If your date column is not continuous, I'm afraid that you should create a table with the date missed and then join the tables to get a continuous date column.

1. Create the Calendar table and don't create the relationship between the original table and the Calendar table.

2. Create the Date slicer with the date column in Calendar table.

3. Create a measure with the formula below to get the records base on your selection.

Measure = IF(SELECTEDVALUE('Table'[Date])<=SELECTEDVALUE('Calendar'[Date]),1,0)

4. Create the MTD measure with the formula.

MTD =
CALCULATE (
    SUM ( 'Table'[Amount] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        MONTH ( 'Table'[Date] ) = MONTH ( MAX ( 'Table'[Date] ) )
            && 'Table'[Date] <= MAX ( 'Table'[Date] )
    )
)

Here is the output.

More details, please refer to the attachment.

Best Regards,

Cherry