Forum Discussion

HotelRM's avatar
HotelRM
Regular Visitor
9 years ago

Create LY Data Column Based on the Existing Filter Selected for TY

  Let's start by saying this is my very first post in the forum - I'm very new to Power BI   To give you some background information, we use Fiscal Year with Financial Periods of 4 weeks, 4 weeks,...
Need Help
Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

HotelRM

 

Hi, please check if this is the desire result

 

HotelRM's avatar
HotelRM
Regular Visitor
9 years ago

Vvelarde

 

Thanks Victor. Rooms Sold for 2007 - P11 should be 1,153. You can see it directly in your table if you change the filter to 2007; your Rooms Sold for 2007 should be the same result as Rooms Sold LY when the filter is on 2008.

 

Thanks,

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    HotelRM

     

    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.

     

     

     

     

     

     

  • HotelRM's avatar
    HotelRM
    Regular Visitor
    9 years ago

    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.

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    HotelRM

     

    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)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • HotelRM's avatar
    HotelRM
    Regular Visitor
    9 years ago

    Vvelarde

     

    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.

     

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    HotelRM

     

    To close my questions

     

    What is the problem in this chart.

     

  • HotelRM's avatar
    HotelRM
    Regular Visitor
    9 years ago
    It displays the incorrect data for LY.