Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Month on Month Growth % in the given table

I have this table as below
and I have dervied month_number from the Month_year column.
I want to calculate the MOM growth on Online_Traffic in calculated column which will tell me what is the % compared last month.
How Do I achieve this with dax.
please help me in this.




Community Support
Community Support

Hi @Anis_Hussain ,


Please create a new measure:

MOM growth = 
VAR __city = MAX('Table'[City])
VAR __mon_num = MAX('Table'[Month_number])
VAR __pre_value = CALCULATE([Total_Online_Traffic],'Table'[City]=__city && 'Table'[Month_number] = __mon_num - 1)
VAR __result = DIVIDE([Total_Online_Traffic]-__pre_value,__pre_value)


Best Regards,

Community Support Team


If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors