Show Current & Previous Year Values in a bar chart based on Year and Month Selection in the slicer

[Arul]

Hi All,

My requirement is, I need to show selected year and previous year values in a bar chart based on Year & Month selection in a slicer. For that, I have already created a measure which is using dates from two date tables one (calendar table) which is connect to fact table and other date table (previous dates table) is connected to calendar table by making inactive relationship. Please refer the formula for measure attached below.

Selected Sales Price = 
VAR _referenceDate = MAX(dim_calendar[date])
VAR _previousDates = DATESINPERIOD('Previous Dates'[Date],_referenceDate,-2,YEAR)
VAR _result = 
CALCULATE(
    SUM(sales_table[list_price]),
    REMOVEFILTERS(dim_calendar),
    KEEPFILTERS(_previousDates),
    USERELATIONSHIP(dim_calendar[date],'Previous Dates'[Date]))
RETURN _result

This measure is providing correct results whenever I select year selection but it is not providing correct result for month slicer selection.

Your help would be highly appreciated.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Arul]

@lbendlin , I found the solution. Thanks for the response.