Forum Discussion
asl10
Helper I
Helper ICompare 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...
parry2k
Super User
Super UserHi 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.
asl10Helper I
Helper IHi , thank you for the input.
If you see my initial post there is a picture where im able to do that with 2 seperate graphs as well.
My question was how to combine them into one! Maybe wth the help of some DAX formula or some other magic trick...
If you see my initial post there is a picture where im able to do that with 2 seperate graphs as well.
My question was how to combine them into one! Maybe wth the help of some DAX formula or some other magic trick...