Forum Discussion

asl10's avatar
asl10
Icon for Helper I rankHelper I
9 years ago

Compare Feature Sales with Previous Year Feature Sales

Hi, I would like to compare sales of reserved bookings (Hotel) for 2017 with reserved booking sales for the same period last year?   E.g. Based on Input Date of users 2016 i can see the figures fo...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

Hi there,

 

From your table looks like you just need to calcualte YTD Revenue and here is what you can use for that:

 

YTD Sales = TOTALYTD(SUM(Sales[Revenue]),'Calendar-1'[Date])

I assumed you already have calendar table and linked to Sales Table on Input Date, make sure relationship is single as shown below.

 

 

Results for two different dates

 

 

Hope it is helpful, let me know if need further assistance.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

This will be your formula for previous year YTD

 

mYTD Previous Year = TOTALYTD(SUM(Sales[Revenue]),DATEADD('Calendar-1'[Date],-1, YEAR))