MDX Query to get Last Year data without filtering based on current month

Question

i have been doing a query to get previous year value in MDX but can't the the desired output. In sql i would do it like this. Question is how do i apply this query in MDX?

select data1, sum(data2) as sumthisyear, sumlastyear from table1 a left outer join ( select data1, sum(data2) 'sumlastyear' from table1 where tableyear = 2017 group by data1 ) b on a.data1 = b.data1 where tableyear= '2018' and datafilter = 'SampleFilter' group by data1, sumlastyear

SSAS Cube Structure Image

I have done some research and did mdx function like parallelperiod but not giving the correct values as data are filtered based on 2018 year.

Here's my MDX query

CREATE MEMBER CURRENTCUBE.Measures.[SPLY Registered Sales] AS
    iif( [DimProdDate].[Dates].CurrentMember Is
         [DimProdDate].[Dates].[All].LastChild,

         ( PARALLELPERIOD( [DimProdDate].[Dates].[Calendar Year],
                           1,
                           Tail( NonEmpty( [DimProdDate].[Dates].[Full Date].MEMBERS,
                                           [MEASURES].[Registered Sales]),
                                 1
                               ).Item(0)
                         ),
           [MEASURES].[Registered Sales] ),

         ( PARALLELPERIOD( [DimProdDate].[Dates].[Calendar Year],
                           1,
                           [DimProdDate].[Dates].CurrentMember 
                         ), 
           [MEASURES].[Registered Sales] )
      );

Any help will be very much appreciated.

Thanks!