Monthly growth percentage according to slicer start date

[EGRF]

I'm trying to create a contract dashboard which I want to show the month on month growth % metric card according to slicer month selected. Growth % = (total current month - total previous month) / total previous month

Sample data as below.

Contract no	Start	End	Monthly Amount
1	1/4/2021	31/3/2022	$100
2	1/5/2021	30/4/2022	$200
3	1/5/2021	30/4/2022	$300
4	1/6/2022	30/5/2023	$400

If user select 'Apr 2022' on the slicer the card should calculate as:

( ($200+$300) - ($100+$200+$300) ) / ($100+$200+$300) = -16.67%

If user select 'May 2022' on the slicer the card should calculate as:

( $0 - ($200+$300) ) / ($200+$300) = -100%

How do I go about this?

[EGRF]

Thanks for the solution!

[amitchandak · Accepted solution]

@EGRF , Check if the period comparison method in this file can help

we move the max date in current employee(open contract in your case)