I am trying to calculate a YOY PMPM % change using the formula below, but I am not getting the expected results. What is wrong with my formula?
(CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) -0
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
) -
(CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) - 11
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
))) / ( CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) - 11
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
)
)
(CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) -0
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
) -
(CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) - 11
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
))) / ( CALCULATE (
CALCULATE (
[PMPM],
FILTER (
ALL ( Calendar ),
Calendar[DateID]
>= MIN ( Calendar[DateID] ) - 11
&& Calendar[DateID] <= MAX ( Calendar[DateID] )
)
),
FILTER (
Calendar,
Calendar[Month] < DATE ( 1991, 1, 1 )
|| Calendar[Month] > DATE ( 1992, 11, 1 )
)
)
)