Let’s start by getting the parallel period:
WITH MEMBER [Measures].[Sales Amount PY]
AS
(
[Measures].[Sales Amount]
, ParallelPeriod
([Date].[Calendar].[Calendar Year] // Level
, 1 // number of periods back
, [Date].[Calendar].CurrentMember) // Start member
)
, format_string = "Currency"
