Set Analysis for selecting previous year's December data as base value for all the months?

[bhaveshp90]

Hello,

I want to select December month data of previous year as the baseline value for all the months for As Sold Dec (Updated OEC) as shown in the below image

But this expression is not working as shown in the image below (Snapshot_Date format like 2018-08-31, 2018-09-30, etc)

=Sum({<Month={"$(=max(Snapshot_Date)'}Snapshot_Date(MonthEnd(Max(Snapshot_Date), -1),'MMM-YY'))"}>}As_Sold)

What wrong am I doing here? Any help is greatly appreciated

thanks

Bhavesh

[bhaveshp90]

thank you neelamsaroha1575‌. This expression is working for this table So I am closing this thread. Can you please look into this Expression for getting December month value for previous Year?