Filtering a date range with a period slicer and YoY calculation

[kterlikowski]

Hello,

I have a date filter and a period filter on a page:

I would like the period filter to affect the date range but in a way that will allow me to make YoY comparisons. This is how dim_date and the date (period) filter are set up:

I want to use the period filter as a selector for the date range so that calcualatoins like this one can be done:

Revenue Current Year = CALCULATE(SUM(fact_sales[sales_net]), fact_sales[type]="S")

Revenue Previous Year = CALCULATE([Revenue Current Year], SAMEPERIODLASTYEAR(dim_date[Date]))

Many thanks for help in advance!

[danextian · Accepted solution]

Hi @kterlikowski 

Use REMOVEFILTERS on your filter table similar to my screenshot below.

Revenue Previous Year =
CALCULATE (
    [Revenue Current Year],
    SAMEPERIODLASTYEAR ( dim_date[Date] ),
    REMOVEFILTERS ( 'Date Filter' )
)

Please see the attached sample pbix.