YTD calculation with SamePeriodLastYear brings back same values

[sinadvd]

Hello everyone, 
I'm trying to simulate an exercise from Microsoft PowerBi course in EDX.org, about using meassures and more specifically YTD and SamePeriodLast Year command. 

The powerbi project file provided by the course is here : Github Download Link 

Using these data, by  applying DAX commands for YTD Revenue  and LY YTD as below, the numbers I get back are the same for both years which makes the calculation for YTD Variance to be zero.

YTD Revenue = TOTALYTD(SUM(Sales[REevenue]),'Date'[Date])

YTD LY = CALCULATE([YTD Revenue],SAMEPERIODLASTYEAR('Date'[Date]))

YTD Var = [YTD Revenue] - [LY YTD]

I would appriciate if you can help me with choosing the right Date table and fixing the LY YTD

[amitchandak · Accepted solution]

@sinadvd , looking at screenshot , I doubt either the join with date table is disabled or not there. Please check the join.

Make sure the date table is marked as the date .

The formula seems correct for LY you can also try

YTD LY = TOTALYTD(SUM(Sales[Reevenue]),dateadd('Date'[Date],-1,year))

[sinadvd]

Thank you so much! the lack of relational connection was the reason!