Home > other >  Month over Month Percentage Change
Month over Month Percentage Change

Time:01-06

I'm trying to find a way to visualize or calculate a table that displays growth or percentage change positive or negative in power bi. Is there a quick way to display that on a visual? Using Excel it would be easy to cell reference for example but how would I demonstrate this on Power BI.

The data inputted raw from SQL Server is as follows in record:

Table: Sheet1 Col: MONTH(Whole Number),CustomerID(Whole Number),CustomerName(Text),Sales Rep (Text),Sales total (decimal),Month Name(text)

Month was original extracted from SQL Server as a datepart value. I was unable to display simply the month name in Power BI, so I created a new field with the month name and its corresponding number date part.

I want to display the following:

Filter: Sales Rep

Months    total   %  difference MoM growth
Jan        $
Feb        $
Mar       ...
...       ...

enter image description here

  • Related