Forum Discussion
Power BI Percentage Growth
I have created a matrix visual where calcuating the % Growth Month over Month change. I have sorted the months in FInacial Year format and getting percentage value as 0 when taking the Month sorted f...
cengizhanarslan
Super User
Super UserStep 1) Use a proper calendar table
Mark it as Date Table in the model.
Step 2) Use the Date column in the time calculation
Example MoM growth measure:
MoM Growth % =
VAR CurrentValue =
SUM ( 'FactTable'[Value] )
VAR PreviousValue =
CALCULATE (
SUM ( 'FactTable'[Value] ),
DATEADD ( 'Calendar'[Date], -1, MONTH )
)
RETURN
DIVIDE ( CurrentValue - PreviousValue, PreviousValue )
Step 3) Use Month label only for display
In the matrix you can use something like:
- Rows → Branch
- Columns → Calendar[Fiscal Month Name]
- Sort that column by → Calendar[Fiscal Month Number]
Step 4) Check the relationship
Ensure that "Calendar[Date] → FactTable[Date]" is the active relationship.
Hi I followed this method not getting percentage as 0 but a constant 0.01 percentage please help me out