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

 

Ok, I think i have the solution, but take much time reproduce your tables.Please post sample Data.

 

Regards,

HotelRM's avatar
HotelRM
Regular Visitor
9 years ago

Hi Victor,

 

Not sure if I can upload them to the forum somehow but here they are in OneDrive:

FiscalCalendarSample 

DataSample

 

Many thanks for giving it a go!

 

 

  • 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.