Skip to main content
cancel
Showing results for 
Search instead 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

Reply
lyly
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;
Screenshot 2023-01-19 143127.png

5 REPLIES 5
tamerj1
Super User
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?

Hello,


I have table like below

DonorIDJoined Date
111111115/01/2021
222222217/02/2021
33333323/01/2021
4444442/02/2021
5555551/03/2021
66666663/03/2021
777777711/03/2021
888888814/03/2021

 

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

MonthCount of Donor ID%growth rate
Jan844%growth rate
Feb760%growth rate
Mar953%growth rate


what is your sugeestion? 

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:

FreemanZ_0-1674119887554.png

 

@FreemanZ 

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. 

XIB1
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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors