cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

New Member

## How to calculate monthly grow rate %

Hello, I still beginner in power bi,

I want to make the monthly growth rate % for this data can someone help me how to do this using the DAX measure? Here is my table;

5 REPLIES 5
Super User

Hi @lyly

It depends. Is "Month" a month hierarchy of a date column in the same table or is it an independent column in the same table or is it a column from a connected date table?

New Member

Hello,

I have table like below

 DonorID Joined Date 1111111 15/01/2021 2222222 17/02/2021 333333 23/01/2021 444444 2/02/2021 555555 1/03/2021 6666666 3/03/2021 7777777 11/03/2021 8888888 14/03/2021

I need to show a table that show month to month count (DonorID) and %Growth of  each month  like this

 Month Count of Donor ID %growth rate Jan 844 %growth rate Feb 760 %growth rate Mar 953 %growth rate

Super User

hi @lyly

try to add a column like this:

``MONTH = FORMAT(TableName[Joined Date], "MMM")``

plot a table visual with Month column, DonorID column (choose count) and a measure like this:

``````GrowthRate =
VAR _month = MAX(TableName[Month])
VAR _countcurrent = COUNTROWS(TableName)
VAR _countpre =
COUNTROWS(
FILTER(
ALL(TableName),
FORMAT(EDATE(TableName[Joined Date], 1), "MMM") = _month
)
)
RETURN
IF(
_countpre<>0,
DIVIDE(_countcurrent, _countpre) -1
)``````

it works like this:

Super User

That should work but you need to pay attention to the possibility of having multiple years. I would prefer using a YearMonth column preferably from a legitimate date table. The dax would be simpler using time intelligence functions.

New Member

Hi, it could be calculated like this:

``````Growth % =
var _donor = SUM('Table'[Donor])
var _prevdonor = CALCULATE(SUM('Table'[Donor]), PREVIOUSMONTH('Table'[Month]))
return _donor / _prevdonor - 1``````