Forum Discussion

New Member

8 years ago

Growth rate (Month Over Month)

Hi, I want to calculate growth rate for Sales, month over month in absolute & percentage so that i can present it in table & waterfall chart to reflect monthly growth. The data fields are as ...

v-qiuyu-msft

Community Support

8 years ago

Hi nomanzafar,

You can create a measure like below:

Per = var PreMonth = CALCULATE(SUM('Table1'[Sales]),FILTER(ALL('Table1'),'Table1'[Month]=MAX('Table1'[Month])-1 && 'Table1'[Year]='Table1'[Year]))
var CurrMonth=CALCULATE(SUM(Table1[Sales]),FILTER(Table1, 'Table1'[Year]='Table1'[Year] && 'Table1'[Month]='Table1'[Month]))
return
DIVIDE(CurrMonth-PreMonth,PreMonth)