The above tabular information can also be plotted in a bar chart, that'll compare both the current and previous month's sales and the change in percentage can be depicted by a line chart. In order to use the measures that we just created in the previous step, I'll create a table in the Power BI report by including the fields as below. VAR Result = CurrentMonthSales - PreviousMonthSales I have provided the DAX script for all the three measures below.
![excel pivot chart month over month excel pivot chart month over month](https://i.stack.imgur.com/Zn7V2.jpg)
Let's see this in action in the Power BI report. Sales Growth %: To calculate the difference in percentage.Sales Difference: To calculate the difference in sales amount from the previous month.Previous Month Sales: This field will store the previous month's sales values for any given month.I need to create three Measures in the data model to calculate the growth percentage, which are as follows: For illustration purposes, I'll rename this to "This Month Sales". The field that is already available in the database for the Sales Amount is "Total Including Tax".
![excel pivot chart month over month excel pivot chart month over month](https://www.exceldashboardtemplates.com/wp-content/uploads/2016/02/ClusteredStackedColumnChartbyMonthYear.png)
MoM Formula: (This month – Previous month) x 100 / Previous Month= Percentage Growth Finally, in order to calculate the change in percentage, we need to divide the difference by the previous month's value. Once we have this, the next step is to calculate the difference between these two values. In order to be able to calculate this, we need to prepare the data in such a way that we can visualize the Sales Amount for the current month and the previous month for each of the months available in the database. In this example, I have used the and fields in the report.
![excel pivot chart month over month excel pivot chart month over month](https://excelchamps.com/wp-content/uploads/2017/11/add-running-total-in-pivot-table-with-pivot-chart.png)
Period-over-period is an analysis technique in business that measures some value in the present and compares it to the same measurement in a comparable period of time in the past.