Forum Discussion
Create LY Data Column Based on the Existing Filter Selected for TY
Community Champion
I have a doubt
In your original post you want to see daily chart (Selected Year and Previous Year of each Day)
The sum by period is not exactly to a last year period because dates are different.
In 2007 period 11 start on 2/9 and in 2008 start in 31/08.
Vvelarde correct, that's the difficulty, I want to compare the data for all dates that relate to a particular fiscal period in a given year (chosen in the filter) to the same fiscal period in a different year (in this case previous year). That's the reason why I had to create a calendar table with predetermined fiscal periods for fiscal years.
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.
- It displays the incorrect data for LY.