How to show Current Month and Previous Month Data for Selected Month

[myou]

I

I Have  Date Table that has relation ship with other sales data table

I want when I press July the data from Jan until July appear

so for example in the image when I press July, the closingendcatered column will include data from Jan until July

pbix file:

https://www.dropbox.com/s/upz9cbtsvfc48b9/demo.pbix?dl=0

[v-frfei-msft · Accepted solution]

Hi @myou ,

Firstly, we should make the relationship between fact table and date table inactive. Atfer that, to create a measure as below and add it to the table visual.

Measure = 
VAR maxdate =
    SELECTEDVALUE ( Dates[Date] )
RETURN
    IF ( MAX ( Table1[closingENDcatered2020] ) <= maxdate, 1, BLANK () )