Forum Discussion

Tarek78's avatar
Tarek78
Icon for Helper I rankHelper I
3 years ago

Year-Over-Year calculation

Hi Everyone,   I am completely new to Power Pivot and DAX calculations. I have a simple data model with a date table and a fact table with dates and sales generated per date.   Each month, I am g...
DAX
Last Year
year-over-year
YoY calculation
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Tarek78 

you would need some measures with Time Intelligence Functions, like

MTD =
CALCULATE(
SUM(FactTable[Sales]), DATESMTD('calendar'[Date]))
 
LY MTD =
CALCULATE
([MTD], SAMEPERIODLASTYEAR('calendar'[Date]))
 
YTD =
CALCULATE(
SUM(FactTable[Sales]), DATESYTD('calendar'[Date]))
 
LY YTD =
CALCULATE
([YTD], SAMEPERIODLASTYEAR('calendar'[Date]))