Each day level in all the months in a display

[qwaiti27231]

d/m/y

1/1/2020-100

2/1/2020-200

3/1/2020-40

4/1/2020-500

1/2/2020-100

2/2/2020-200

3/2/2020-40

4/2/2020-500

1/3/2020-100

2/3/2020-200

3/3/2020-40

for eg if the march is curent month and last day is 3/3/2020 then its show the values of all previous month  till the particular day which is 3rd    , how do i filter this ??? 

output is  

1/1/2020-100

2/1/2020-200

3/1/2020-40

1/2/2020-100

2/2/2020-200

3/2/2020-40

1/3/2020-100

2/3/2020-200

3/3/2020-40

thank you for your help in advance

[mahoneypat · Accepted solution]

If I understand correctly, you'll need to build some logic into your measure/column to filter using the DAY() function.

For example

Up To This Day Measure =
VAR thisday =
    DAY (
        TODAY ()
    )
RETURN
    CALCULATE (
        [Your Measure],
        FILTER (
            ALLSELECTED ( 'Date'[Date] ),
            DAY ( 'Date'[Date] ) <= thisday
        )
    )

Regards,

Pat