DAX to calculate Month over Month with last year Month

[ofeliajesus]

Hello 

I have the table
Dim_Date

Date_ID	Date	Period	EOM Date
29042021	29/04/2021	2021_04	30/04/2021
30042021	30/04/2021	2021_04	30/04/2021
01052021	01/05/2021	2021_04	30/04/2021
02052021	02/05/2021	2021_04	30/04/2021
03052021	03/05/2021	2021_05	31/05/2021
04052021	04/05/2021	2021_05	31/05/2021
05052021	05/05/2021	2021_05	31/05/2021
06052021	06/05/2021	2021_05	31/05/2021
07052021	07/05/2021	2021_05	31/05/2021
08052021	08/05/2021	2021_05	31/05/2021
09052021	09/05/2021	2021_05	31/05/2021
10052021	10/05/2021	2021_05	31/05/2021
11052021	11/05/2021	2021_05	31/05/2021
	…
26042022	26/04/2022	2022_04	30/04/2022
27042022	27/04/2022	2022_04	30/04/2022
28042022	28/04/2022	2022_04	30/04/2022
29042022	29/04/2022	2022_04	30/04/2022
30042022	30/04/2022	2022_04	30/04/2022
01052022	01/05/2022	2022_04	30/04/2022
02052022	02/05/2022	2022_05	31/05/2022
03052022	03/05/2022	2022_05	31/05/2022
04052022	04/05/2022	2022_05	31/05/2022
05052022	05/05/2022	2022_05	31/05/2022
06052022	06/05/2022	2022_05	31/05/2022
07052022	07/05/2022	2022_05	31/05/2022
08052022	08/05/2022	2022_05	31/05/2022
09052022	09/05/2022	2022_05	31/05/2022
10052022	10/05/2022	2022_05	31/05/2022
11052022	11/05/2022	2022_05	31/05/2022
12052022	12/05/2022	2022_05	31/05/2022

and the table
Table1

Date_ID	Region	Amount
29042021	California	$200.234
30042021	North Central	$650.235
01052021	West	$1,140.890
02052021	West	$2,100.137
03052021	California	$954.543
04052021	California	$654.345
05052021	North Central	$321.654
06052021	South Central	$234.876
06052021	North Central	$1,140.890
08052021	North Central	$2,100.137
08052021	South Central	$954.543
10052021	California	$654.345
11052021	West	$2,100.137
26042022	California	$200.234
27042022	California	$650.235
28042022	North Central	$1,140.890
29042022	South Central	$2,100.137
30042022	North Central	$954.543
01052022	North Central	$654.345
01052022	South Central	$321.654
01052022	California	$234.876
04052022	West	$1,140.890
05052022	West	$2,100.137
06052022	West	$200.234
07052022	California	$650.235
08052022	California	$1,140.890
09052022	North Central	$2,100.137
10052022	South Central	$954.543
11052022	North Central	$654.345
12052022	California	$321.654

Dim_Date and Table1 are joined by Date_ID
There are 12 Periods per year, but they don't exactly match the months of the year. To have a date that can give me the period, I built the column "EOM Date." The original thought was to use date functions, but I need the results broken down by Period like in the example below.

Region	Last Year Period	Last Year's Total Amount	Current Year Period	Current Year Total Amount	% Growth
California	2021_04	$200.234	2021_04	$1,085.345	442.04%
California	2021_05	$2,263.233	2021_05	$2,112.779	-6.65%
Non-California	2021_04	$2,750.372	2021_04	$5,171.569	88.03%
Non-California	2021_05	$6,852.237	2021_05	$7,150.286	4.35%
ALL	2021_04	$2,950.606	2021_04	$6,256.914	112.06%
ALL	2021_05	$9,115.470	2021_05	$9,263.065	1.62%

Any help would be appreciated.

Thank you

[ofeliajesus]

I give it another try ...

I have 

Dim_Date table 

Date_ID	Date	Period	EOM Date
29042021	29/04/2021	2021_04	30/04/2021
30042021	30/04/2021	2021_04	30/04/2021
01052021	01/05/2021	2021_04	30/04/2021
02052021	02/05/2021	2021_04	30/04/2021
03052021	03/05/2021	2021_05	31/05/2021
04052021	04/05/2021	2021_05	31/05/2021
05052021	05/05/2021	2021_05	31/05/2021
06052021	06/05/2021	2021_05	31/05/2021
07052021	07/05/2021	2021_05	31/05/2021
08052021	08/05/2021	2021_05	31/05/2021
09052021	09/05/2021	2021_05	31/05/2021
10052021	10/05/2021	2021_05	31/05/2021
11052021	11/05/2021	2021_05	31/05/2021
	…
26042022	26/04/2022	2022_04	30/04/2022
27042022	27/04/2022	2022_04	30/04/2022
28042022	28/04/2022	2022_04	30/04/2022
29042022	29/04/2022	2022_04	30/04/2022
30042022	30/04/2022	2022_04	30/04/2022
01052022	01/05/2022	2022_04	30/04/2022
02052022	02/05/2022	2022_05	31/05/2022
03052022	03/05/2022	2022_05	31/05/2022
04052022	04/05/2022	2022_05	31/05/2022
05052022	05/05/2022	2022_05	31/05/2022
06052022	06/05/2022	2022_05	31/05/2022
07052022	07/05/2022	2022_05	31/05/2022
08052022	08/05/2022	2022_05	31/05/2022
09052022	09/05/2022	2022_05	31/05/2022
10052022	10/05/2022	2022_05	31/05/2022
11052022	11/05/2022	2022_05	31/05/2022
12052022	12/05/2022	2022_05	31/05/2022

In the ... space I have other dates but for the results doesn't matter 

and I have 

Table1 

Date_ID	Region	Amount
29042021	California	$200.234
30042021	North Central	$650.235
01052021	West	$1,140.890
02052021	West	$2,100.137
03052021	California	$954.543
04052021	California	$654.345
05052021	North Central	$321.654
06052021	South Central	$234.876
06052021	North Central	$1,140.890
08052021	North Central	$2,100.137
08052021	South Central	$954.543
10052021	California	$654.345
11052021	West	$2,100.137
26042022	California	$200.234
27042022	California	$650.235
28042022	North Central	$1,140.890
29042022	South Central	$2,100.137
30042022	North Central	$954.543
01052022	North Central	$654.345
01052022	South Central	$321.654
01052022	California	$234.876
04052022	West	$1,140.890
05052022	West	$2,100.137
06052022	West	$200.234
07052022	California	$650.235
08052022	California	$1,140.890
09052022	North Central	$2,100.137
10052022	South Central	$954.543
11052022	North Central	$654.345
12052022	California	$321.654

The tables are related with Date_ID 

I want to calculate the % of the growth amount for the existing periods between the current year and last year. I know each year can have 12 periods but they don't correspond to normal months to have a date per period I created the EOM Date with this date I can use date functions maybe this helps.
The result that I want

Region	Last Year Period	Last Year Total Amount	Current Year Period	Current Year Total Amount	Percentage  Growth
California	2021_04	$200.234	2021_04	$1,085.345	442.04%
	2021_05	$2,263.233	2021_05	$2,112.779	-6.65%
Non California	2021_04	$2,750.372	2021_04	$5,171.569	88.03%
	2021_05	$6,852.237	2021_05	$7,150.286	4.35%
ALL	2021_04	$2,950.606	2021_04	$6,256.914	112.06%
	2021_05	$9,115.470	2021_05	$9,263.065	1.62%

Thank you 

[lbendlin]

I cannot work with data screenshots. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[lbendlin]

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[ofeliajesus]

Ibendlin takes a look at the data, I can create a pbix if you prefer. Thank you 

[lbendlin · Accepted solution]

Your expected result is not in a good format. See attached for a proposal on how to present the data.

[ofeliajesus]

Thank you works