KPI does not work with Sameperiodlastyear (Month) as target

[Anonymous]

Hello,

I would like to have a KPI which takes the current date's value (measure for total contracts-Contracts) and compare it with the sameperiodlastyear's value (measure for total contracts of same period previous year-SPLYearContracts). When I chose the period as year there is no problem. But I would like to compare the current month's value to same month of previous year. So I drag Month from Calendar Table as trend axis. However, KPI does not show what I would like. When I drag Contracts and  SPLYearContracts with Date, it shows exacltly as it is intended (see below). So my measures are defined right and when I choose Year from Calendar as trend there is no problem. However when I drag month as trend it shows 2022 December Value instead of the latest month which is March.

Trend axis with MonthTrend axis with Year

I have only two years data (2022, 2023). How can I make Power Bi takes as the latest value 7727 (March 2023) and compares it with 5497(March 2022) as it is in the matrix. 

Thanks in advance for the help. Appreciate it. 

Date	SPLYear's Contracts	Contracts	Last Month's Contracts
2022
January		2945
February		3774	2945
March		5497	3774
April		12389	5497
May		13828	12389
June		13785	13828
July		12936	13785
August		13565	12936
September		12732	13565
October		11281	12732
November		7633	11281
December		6769	7633
2023
January	2945	4736	6769
February	3774	6209	4736
March	5497	7727	6209
April	12389		7727
May	13828
June	13785
July	12936
August	13565
September	12732
October	11281
November	7633

[Anonymous · Accepted solution]

Solved with RelativeMonth column in Calendar Table. Please ignore the entry.

Thanks