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
Tarek78's avatar
Tarek78
Icon for Helper I rankHelper I
3 years ago

Thanks! I tried them works fine. 

I also used TotalMTD/TotalYTD and it works perfectly also. 

what's the difference between them? Which one using less resources and size?

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Tarek78 

TOTALMTD is simplified form of CALCULATE([], DATESMTD). The later provides more flexibility when we have fiscal years starting not on Jan 1st.