Calculate Average Growth Rate over Weeks

[mohsenalam]

I would like to calculate growth rate and average growth rate from a table like this

date	region	team	storage
9/1/2023	A	A1	100
9/1/2023	A	A2	20
9/1/2023	A	A3	30
9/8/2023	A	A1	120
9/8/2023	A	A2	25
9/8/2023	A	A3	35
9/15/2023	A	A1	130
9/15/2023	A	A2	30
9/15/2023	A	A3	40

I would like to create a visual showing growth rate for each region and/or team. For instance, the result view should like this

Date	region	team	week-to-week growth	total growth
9/8/2023	A	A1	20%	20%
9/15/2023	A	A1	8.33%	30%

What would be the best way to do that using DAX query?

[BeaBF · Accepted solution]

@mohsenalam Hi!  Create a table visualization and place the following fields in the columns:

• Date
• Region
• Team
• Total Growth (use the Total Growth measure)
• Week-to-Week Growth (use the Week-to-Week Growth measure)

Measures
Total Growth =
SUM('YourTableName'[storage]) - CALCULATE(SUM('YourTableName'[storage]), PREVIOUSMONTH('YourDateTable'[Date]))

Week-to-Week Growth =
DIVIDE([Total Growth], CALCULATE(SUM('YourTableName'[storage]), DATEADD('YourDateTable'[Date], -7, DAY)))

BBF

[mohsenalam]

Thanks @BeaBF 

It worked!