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

Let me explain the business case:

 

For example asOf today, 23/12/16 (Input Date) I have xxxxx Total Revenue for 2017 based on Reservation Date.

 

For Last Year, asOf  23/12/15 (Input Date) what I had in Total Revenue for 2016 based on Reservation Date?

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

1. Bookings (ThisYear) = SUM(Table[Bookings])

2. Bookings (LastYear) = Calculate ( SUM(Table[Bookings]), SAMEPERIODLASTYEAR(Calendar[Date]))

 

let me know if it is not helping u