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...
Adjust this code
% Growth Enrolment MOM =
IF(
ISFILTERED('Booking Live Data'[BC_Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
VAR __PREV_MONTH =
CALCULATE(
SUM('Booking Live Data'[Enrol_Count]),
DATEADD('Booking Live Data'[BC_Date].[Date], -1, MONTH)
)
RETURN
DIVIDE(SUM('Booking Live Data'[Enrol_Count]) - __PREV_MONTH, __PREV_MONTH)
)
The other measures get affected despite using this method this method is not the effective method