powerbi - Power Bi Calculate Growth Over Last Month and Show it in a Matrix

Question

I have a below matrix. I want to calculate the % Growth over month and to show in a matrix

Fields

Expected Output

Company	August	September	GOLM %	Total
EBS-EASEBUSINESS SOLUTIONS	5940	0	-100%	5940
? ? SWEETREAT CAFE	5940	0	-100%	5940
? ? ? ? M/S SPORTS ONE PHARMACY	1188		-100%	1188

Answer 1

Maybe you can do something like this;

First create a DAX table by using modelling pane;

Growth = 
VAR CurrentMonth = FORMAT(TODAY(), "MMMM")
VAR PrevMonth =  FORMAT(EOMONTH(TODAY(),-1), "MMMM")
VAR tmp1 = SELECTCOLUMNS('Source Data',
                "SV_PrevMonth", CALCULATE(
                                    SUM('Source Data'[SALES VALUE]), 
                                    'Source Data'[Month Updates]=PrevMonth), 
                "SV_CurrentMonth", CALCULATE(
                                    SUM('Source Data'[SALES VALUE]), 
                                    'Source Data'[Month Updates]=CurrentMonth), 
                "PN", 'Source Data'[ProductNameFull],
                "CN", 'Source Data'[CustomerNameFull],
                "CP", 'Source Data'[Company]
            )  
return tmp1

Then add a measure to your table

GrowthPercentage = CALCULATE(DIVIDE(SUM(Growth[SV_CurrentMonth]) - SUM(Growth[SV_PrevMonth]), SUM(Growth[SV_PrevMonth]),0))*100

The result wil be like;