Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
giorgiokatr
Helper V
Helper V

Dates in period for previous year

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? ?
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

2 REPLIES 2
giorgiokatr
Helper V
Helper V

Thanks!

Fowmy
Super User
Super User

@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


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.