How to calculate percent change from month to month

lnschne2 — Wed, 01 Feb 2023 15:48:33 GMT

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!

Re: How to calculate percent change from month to month

Anonymous — Wed, 01 Feb 2023 16:27:58 GMT

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)

topic Re: How to calculate percent change from month to month in DAX Commands and Tips

How to calculate percent change from month to month

Re: How to calculate percent change from month to month