Forum Discussion
Create LY Data Column Based on the Existing Filter Selected for TY
Community Champion
Sorry i don't follow you.
Don't know what is the desire result.
The compare is Daily? by Period?
Create a result table from Year 2008 and Period 11 and posted. (In Excel if you want)
I'm glad I mentioned I'm new to Power BI! perhaps it's not possible!
The result I want is just like the screenshot of the dashboard I posted at the begining. But to include in the daily stats bars side by side to compare LY (similar to what you did before - just with the correct data), and maybe some totals for the period on top of the dashboard (at the moment it only shows the current year).
In simple terms: daily rooms sold for the a fiscal period TY compared to the same fiscal period LY
As mentioned before, the data for LY (or for 2007 P11) is the same you would obtain for TY if you were to click on 2007 instead of 2008 - obviously in the graph I only need TY's dates or it could just be the number of the day (i.e. 1 to 28):
I guess the issue might be the dates themselves, perhaps if I had a column in the calendar with just the day of the fiscal year? i.e. 1 to 28 in this particular case then it might be easier. Anyway, I'm just thinking out loud as I don't really have a clue!
Anyway, thanks again for giving it a go. I'll probably have limited access over the weekend but would definetely pick it up next week if I don't get a chance in the next couple of days.