Forum Discussion
Solved
YTD calculation with SamePeriodLastYear brings back same values
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 projec...
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))
amitchandak
Super User
Super Usersinadvd , 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))
Thank you so much! the lack of relational connection was the reason!
