Forum Discussion

christiaanvr's avatar
christiaanvr
New Member
2 years ago

Help needed - create metric based on 2 datasets. Use one total form DS1 and use 2 columns from DS2

Hi there, I am not getting it so I ask for help.   I have 2 datasets. One is a dataset with room checkins on each day. So I can pick the TOTAL of one Day. So I have TOTAL GUEST IN for e.g. 28-03-20...
Need Help
Tips and Tricks
Tutorial Requests
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • christiaanvr's avatar
    christiaanvr
    New Member
    2 years ago

    Hi there lbendlin thanks for your response.

     

    I have added the datasets, for one 2 hours ( every 15 mins the IN and OUT coutn of people) below, and the other data set for 8 rooms the checkin's showing the number of people.

     

    So we need to SUM UP the number of persons in the rooms, that's our starting point at 03:00 AM each day. So that represents the occupancy in the hotel. Then Use that number of persons to INCREASE or DECREASE by the number of people ENTERING THE HOTEL (IN) or LEAVE the HOTEL (OUT), and this keeps calcultaitng during the day until 02:59. Then It needs to LOOK UP the # of people in ROOMS on the next day, and then INCREASE/DEcREASE by # of IN and OUT. 

    Representation = see screenshot.


    Visitors counted

    DateINOUT
    mrt 31, 2024 07:0013
    mrt 31, 2024 07:1522
    mrt 31, 2024 07:3023
    mrt 31, 2024 07:4500
    mrt 31, 2024 08:0022
    mrt 31, 2024 08:15210
    mrt 31, 2024 08:3000
    mrt 31, 2024 08:4527

     

    Rooms occupied

    DateRoom ## of persons
    31-03-20243012
    31-03-20243021
    31-03-20243031
    31-03-20243042
    31-03-20243052
    31-03-20243062
    31-03-20243071
    31-03-20243082

     

      • christiaanvr's avatar
        christiaanvr
        New Member
        2 years ago

        lbendlin thanks for the help - but to reflect your suggestion to show in a waterfall chart , in that type of graph I don't see the total # of people inside the hotel. It only shows me a starting point # of people and then in red/green bar the # of people IN or OUT counted.

         

        I want to see the total number of people as a number in a graph over time for all days in 15min. So this is not really what I am looking for. Like the example screenshot.. the yellow line I would like to represent:

        - hotel rooms guests (number) Plus and MINUS the IN & OUT counts during the dya. So taht yellow line wil show rolling total over the day

        - the green/blue bar shows the IN & out counts to present me peak times for visitors