Display Current Month/Year and Previous Month/Year counts based on slicer.

Hi,thedataprofile 

Regarding the issue you raised, my solution is as follows:

1.First I created the following table based on your description:

2.Then create a calculated table that does not have a relationship with any other table to ensure that the slicer does not affect the source data, and then use the newly created calculated column as the slicer:

 

Table 1 = CALENDAR(MIN('Table'[DateMonth]),MAX('Table'[DateMonth] ))

 

3. Then create the following measure swapping it with the SCORE column in the visualization chart:

 

Measure = 
VAR __slicer_Year = YEAR(MAX('Table 1'[Table_DateMonth]))
VAR __Slicer_Month = MONTH(MAX('Table 1'[Table_DateMonth]))
RETURN 
IF(MONTH(MAX('Table'[DateMonth]))=__Slicer_Month&&YEAR(MAX('Table'[DateMonth]))IN{__slicer_Year,__slicer_Year-1},AVERAGE('Table'[Score]))

 

4.Here's my final result, which I hope meets your requirements.

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Leroy Lu

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