How to calculate percent change from month to month

[lnschne2]

Hello, I am new to Power BI.  I am trying to calculate a month to month percent change.  See the screenshot of the data below.  

This is a preview of what the data looks like 

I'm trying to get the difference between say Jan. 2021 (273) and Jan 2022 (248).  

First, I calculated the total admitted 

TotalAdmitted = CALCULATE(Sum(MarCom_Geomarket[Admitted]))

Second, I tried to calculate the total admitted last month or last year to get the month over month difference and no data was generated. 

MoM Diff =

VAR CURRENTVAL = [TotalAdmitted]

VAR PREVVAL =

    CALCULATE(

        [TotalAdmitted],

        PREVIOUSMONTH('MarCom_Geomarket'[ApplicationSubmittedDate])

    )

RETURN

   IF(

       [TotalAdmitted] <> BLANK(),

        DIVIDE(CURRENTVAL - PREVVAL, PREVVAL)

    )

I also tried using DAX using the SAMEPERIODLASTYEAR and PARARRELPERIOD

Total Admitted LY = CALCULATE(SUM(MarCom_Geomarket[Admitted]), SAMEPERIODLASTYEAR(MarCom_Geomarket[ApplicationSubmittedDate])

Total Admitted LM = CALCULATE(SUM(MarCom_Geomarket[Admitted]), PARALLELPERIOD(MarCom_Geomarket[ApplicationSubmittedDate],-1,MONTH))

Nothing comes up when I add the field to the table 

Anyone have know what might be going wrong or what should be tried? 

Thanks so much for your help! 

[Anonymous · Accepted solution]

@lnschne2 
First you need a date calendar.
Then

 Last Month admitted = 
CALCULATE(SUM(Table[Admitted]),DATESBETWEEN(date_dim[Date],DATE(YEAR(TODAY()),MONTH(TODAY())-1,01),DATE(YEAR(TODAY()),MONTH(TODAY()),01)-1))

Last Year Admitted = 

Last Year Admitted = CALCULATE(SUM(Table[Admitted]),date_dim[Year]=YEAR(TODAY())-1)