Dates in period for previous year

[giorgiokatr]

i have a radio slicer (year month)

when i select 2022-07  i have this dax to show customers from 5-7/2022

CALCULATE(DISTINCTCOUNT(ActiveCustomers[CUSTOMERID]),DATESINPERIOD('Table'[Date],MAX('Table'[Date]),-3,MONTH))

how can i show the same for previous year (5-7/2021) when 2022-07 slicer is selected? ?

[giorgiokatr]

Thanks!

[Fowmy · Accepted solution]

@giorgiokatr 

You can use the same measure with within this new measure/

LY Measure =

CALCULATE (
    [CurrentMeasure],
    SAMEPERIODLASTYEAR ('Table'[Date])
)