How can I add month wise Growth %?

[moulshree172]

I need to add month-wise Growth % to the table on the right in the 'GRS Wise Retailers Added Per Month' page.

I am getting only growth % according to the state but not month wise. any idea how it can be done?

I am attaching the file's path below:

https://ifitech-my.sharepoint.com/:u:/g/personal/moulshree_dhanawade_ifi_tech/ESr5NWpzordDnLrcqcCY1G...

[amitchandak]

@moulshree172 , Not able to check the file yet. But you can use time intelligence with date calendar and get diff between, MTD and LAST MTD

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

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 :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[moulshree172]

Hello Amit, I have created growth % measure but my month is not aligning with it. I need to display my growth % month wise.

[v-easonf-msft]

Hi,  @moulshree172 

What is "month wise Growth %"?

Can  you explain to me its calculation logic, or show me you expected result.

And I also  find a measure called "MonthGrowth %",is there any connection between measure"MonthGrowth %" and the measure "month wise Growth % "you mentioned?

Best Regards,
Community Support Team _ Eason

[moulshree172]

Month wise growth % is just growth % but by month and state wise. There is no relation between month % column.