Solved: Dates in period for previous year

giorgiokatr · ‎08-31-2022

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? ?

Fowmy · ‎08-31-2022

@giorgiokatr

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

LY Measure =

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

giorgiokatr · ‎08-31-2022

Thanks!

Fowmy · ‎08-31-2022

@giorgiokatr

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

LY Measure =

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

Did I answer your question? Mark my post as a solution! and hit thumbs up

Dates in period for previous year