Hi
You can use the following measures 🙂
OBS: you maight have to change ; to , in the code.
CurrentYear = SUM(Your[Value])
LastYear =
VAR MonthsWithSales =
FILTER (
VALUES ( 'Calendar'[Date] );
[CurrentYear] > 0
)
RETURN
CALCULATE(
CALCULATE([CurrentYear];SAMEPERIODLASTYEAR('Calendar'[Date]));
MonthsWithSales
)
GrowthPct =
VAR MonthsWithSales =
FILTER (
VALUES ( 'Calendar'[Date] );
[CurrentYear] > 0 && [LastYear] > 0
)
VAR CY = CALCULATE([CurrentYear];MonthsWithSales)
VAR LY = CALCULATE([LastYear];MonthsWithSales)
VAR Result =
IF (
NOT ISBLANK ( CY );
DIVIDE (
CY-LY;
LY
)
)
RETURN
Remember that you must have calender dates without gaps.
Therefore did i use the following code to create a calender tabel.
OBS: remember to create the relationship in your model.
Calender =
VAR MinYear = YEAR ( MIN ( Your[Date]) )
VAR MaxYear = YEAR ( MAX ( Your[Date]) )
RETURN
ADDCOLUMNS (
FILTER (
CALENDARAUTO( );
AND ( YEAR ( [Date] ) >= MinYear; YEAR ( [Date] ) <= MaxYear )
);
"Calendar Year"; YEAR ( [Date] );
"Month Name"; FORMAT ( [Date]; "mmmm" );
"Month Number"; MONTH ( [Date] );
"Weekday"; FORMAT ( [Date]; "dddd" );
"Weekday number"; WEEKDAY( [Date] );
"Quarter"; "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1
)
Result
