Sameperiod from date range but for a selected year from Year filter

[angeleyes_7181]

Hi I am working on a measure where the counts are dependant on the date range selected. There is another measure where I have to calculate the counts for the date and month from the date range slicer but year from a chosen Year filter. I am using a date dimension table for date range and year filters

Appreciate if anyone can help with this

[angeleyes_7181]

@Anonymous  Thanks for your reply but the above doesn't work. I should be able to select a year irrespective of daterange and teh calculation should give me values for the selected year but for range for day and month from the date range filter

[Anonymous · Accepted solution]

Hi, @angeleyes_7181 

Select Date Slicer, Click the format and select edit interactions. Click the None to disconnect the two slicers 

You can learn more from the following link:

Change how visuals interact in a report - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi, @angeleyes_7181 

I create a sample table:

You can try the following DAX expression:

SamePeriodCount = 
VAR SelectedYear = SELECTEDVALUE('Table'[Year])
VAR StartDate = MIN('Table'[Date])
VAR EndDate = MAX('Table'[Date])
VAR SamePeriodLastYear1 = 
    CALCULATE(
        COUNT('Table'[ColumnToCount]), 
        FILTER(
            ALL('Table'), 
            'Table'[Year] = SelectedYear && 
            'Table'[Date] >= StartDate && 
            'Table'[Date] <= EndDate
        )
    )
RETURN
SamePeriodLastYear1

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.