Return growth percentages

[Syndicate_Admin]

How is it going!

I have the following table with sales, and annual cumulative sales broken down by months. when I add the % growth the months of January are calculated based on the previous year, and what I need is that everything is recalculated from the beginning as the accumulated sale is doing. What would the measure applied for this column look like?

[v-jingzhang · Accepted solution]

Hi @Syndicate_Admin 

You can add a Date table to your model and use the following measure. Add an IF condition to tell whether a month is January. For January, it will return blank. You can change it per your need. 

Monthly Growth = 
VAR _previousSales = CALCULATE(SUM('Table'[Sales]),DATEADD('Date'[Date],-1,MONTH))
VAR _currentSales = SUM('Table'[Sales])
VAR _growth = DIVIDE(_currentSales-_previousSales,_previousSales)
RETURN
IF(MAX('Date'[Month])="January",BLANK(),_growth)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Syndicate_Admin]

Thank you very much, if I could solve it successfully

[amitchandak]

@Syndicate_Admin , You can use time intelligence with date table

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))

or

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA