roll back one year respect to latest date

[ANU2]

how can i roll one year backwards. if new dates are coming then the rolling can automatically updates. how can it possible? This is the table of my input:

how can i create a query if the  latestdate  to one year backwards &count the males one year backward with respect to latest year.

[TomMartens]

Hey,

I'm not sure if I fully understand your requirement.

But maybe this measure counts the no of males for the last year:

Measure = 
var maxYear = YEAR(MAX('Simple Facts'[Date]))
return
CALCULATE(
    DISTINCTCOUNT('Simple Facts'[ID])
    ,'Simple Facts'[GENDER] = "M"
    ,YEAR('Simple Facts'[Date]) = maxYear
)

Please keep in mind that you have to adjust the name of the column in the statement above.

Hopefully this is what your are looking for

Regards

Tom