Forum Discussion
Helper ICompare Feature Sales with Previous Year Feature Sales
Impactful IndividualA little trouble understanding what you're trying to do - here's the basics of calculating This Year vs. Last Year
Bookings (ThisYear) = SUM(Table[Bookings])
Bookings (LastYear) = CALCULATE( [Bookings (ThisYear)], DATEADD(Calendar[Date], -12, MONTH))
Let me know if this helps.
asl10Let 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
Resident Rockstar
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
- austinsense
A few more questions ...
1. Are the input date and reservation dates two separate fields in the model?
2. Looking into next year, when you choose 23/12/16 which reservation dates in the next year do you expect to see?
3. Same question. Looking into last year, when you choose 23/12/16 which reservation dates in the last year do you expect to see?
- asl10
Hi to all and thank you for the thinking process...
I have a Calendar table that is based on the Reservation Date. All the revenue is based on the Reservation Date.
The revenue table has 2 date fields. Reservation and Input dates.
Business wise, looking into the next year asOf today the information is there, as reservations are coming in, I can look into the next year's revenue.
Looking into Last Year i must be able to filter this by Last Year's Input Date asOf 23/12/2015 and see what Revenue I had in 2016.
I can do this by having seperate graphs with seperate filters for Input Year. Graph 1 (Input Year <2017, Reservation Year 2017), Graph 2 (Input Year <2016, Reservation Year 2016).
Thus, I'm asking how I can combine this into one graph?
Thank you for your time.
