Forum Discussion

grifdoogindoggy's avatar
grifdoogindoggy
Frequent Visitor
4 years ago

Displaying Reservations By Day

Hello, I am new to Power BI and I'm struggling to figure out how to display information properly. The goal is to compare the most recent past week reservations in our system to the previous year past week. That is to say, last weeks Monday to Sunday compared to the previous year. I have optimized my query to pull the necessary data so it lines up day to day and not just date to date.

 

Pulling the data is taken care of, it's displaying it in Power BI which is difficult for me. I would like to have a bar graph displaying current year Monday number of reservations next to PY Monday, current year Tuesday number of reservations compared to PY Tuesday, and so on. However, even if I make separate columns that filter the data entries to year or day of week, I don't know how to separate the days by year.

 

Anything helps, let me know if more information is needed.

 

Thank you.

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi grifdoogindoggy 

     

    This blog should be helpful: Compare Sales With Last Year on Day in Week in Power BI | barmartland

     

    You need to create two measures, e.g. [Reservations this year] and [Reservations last year]. Then put these measures into a bar chart as Values field.

     

    If you need further help, please provide some sample data and expected output. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.