Dax for YoY comparison with slicer

[pdory]

Hi all, 

I have a simple data model. It includes a fact table (Tickets) related to a date table (Calendar) based on the creation date of the ticket.

I want to measure the following:

1. Count of tickets opened for a selected period on a slicer 
2. The count of tickets opened for the same period minus 365 days
3. Measure the percentage change between 1 & 2.

I'm struggling to write a Dax for measures 2 & 3 that will dynamically adjust based on the slicer selection (date). Being able to use a slicer to determine the time period is a must have, however I'm open to different options (single date slicer vs multiple date slicers). 

Is there any way to achieve this YoY comparison dynamically using slicer?

Thanks in advance.

[Ashish_Mathur · Accepted solution]

Hi,

Assuming slicers have been created from the Calendar Table, try this measure

Measure = calculate([your measure],sameperiodlastyear(calendar[date]))

Hope this helps.

[pdory]

Ughh I overcomplicated my Dax with a bunch of filters + used the wrong date columns. Should have known better. Thanks for the reply Ashish, sometimes I need to be reminded that simple can be better.

[Ashish_Mathur]

You are welcome.

[parry2k]

@pdory check this video on my YT channel: Explore SAMEPERIODLASTYEAR & PARALLELPERIOD Time Intelligence functions? Are they same? - Part 5 - Y...

[pdory]

Thanks for the reply and video. I just subscribed to your channel. 

Cheers!